View Single Post
  #1   Report Post  
Duke Carey
 
Posts: n/a
Default

You cannot 'center' them and have the commas align. You can, however, use
custom formats to make them right aligned yet mostly in the center of the
column.

Select the range of cells you want to 'center' and then choose
FormatCellsNumber
In the left hand panel select Custom, then use this text in the Type line:

#,##0;-#,##0

Now choose the Alignment tab and set the Horizontal to 'Right (Indent)' Now
adjust the Indent level to 3 or 4 and click on OK

If the numbers are too far left, reduce the indent level a little. If they
aren't far enough left, raise it a little

"bacai" wrote:

I am running Excel 2002 on XP.

I have a wide column and all the numbers in the column are six or less
digits. I would like to center the numbers and have them comma align. How
would this be accomplished?

All help appreciated