Readability is an important part of spreadsheet design. Centering data elements within a column is one way to increase the "white space" to the left and right of an entry.

To create this macro: 

STEP 1:  ALT-T (Tools) |  M (Macro)  |  R (Record Macros) |  CenterText |  TAB  | Q |  TAB to "Store macro in" |  Select "This Workbook"  |  ENTER

STEP 2:  ALT-O (Format)  | E (Cells)  |  CTRL-TAB (Alignment)  |  ALT-H (Horizontal) |  C (Center)  |  ENTER 

STEP 3:  Click on the little black square in the macro box that appears on your screen. This will stop the Record mode.

Enter the numbers 1, 2, 3, 4, and 5 in any column or row you wish. Highlight all (or just some) of the cells you entered data into. Press Shortcut Key CTRL-Q. The data in the highlighted cells should now be centered.