Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Align $ sign next to numbers | Excel Discussion (Misc queries) | |||
Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) |