Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Aligning decimals in Excel ...
How can I align decimals other than using right justify in Excel 2000? I
prefer the numbers to appear centered within the column, but with the decimals in alignment. The Center tool only gives me the former. All numbers have only one decimal place, but have various digits before the decimal. |
#2
|
|||
|
|||
First, center the column, then play with the question marks to display
exactly what you're looking for. You can start with this custom format, then revise to suit: ?,???,???.0?? -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "hogon" wrote in message ... How can I align decimals other than using right justify in Excel 2000? I prefer the numbers to appear centered within the column, but with the decimals in alignment. The Center tool only gives me the former. All numbers have only one decimal place, but have various digits before the decimal. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
How do I remove decimals of IP address in excel? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Aligning Two Lists in Excel | Excel Discussion (Misc queries) |