Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Text Alignment in Excel Cells
I am working with a spreadsheet containing numbers of varying values (i.e.,
100, 1100, 11000, 0.1, etc.). I am trying to find out if there is a way to BOTH center AND right justify numbers within columns of cells so that they align by the last digit on the right. Obviously, just pressing center, left or right justify won't do it. Help would be appreciated. |
#2
|
|||
|
|||
Hi Eduardo,
See the table in http://www.mvps.org/dmcritchie/excel...htm#cellformat 0.????_);(0.????);0.????;@ [align on decimal point] --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Eduardo M" <Eduardo wrote in message ... I am working with a spreadsheet containing numbers of varying values (i.e., 100, 1100, 11000, 0.1, etc.). I am trying to find out if there is a way to BOTH center AND right justify numbers within columns of cells so that they align by the last digit on the right. Obviously, just pressing center, left or right justify won't do it. Help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
can i get excel to warn me if text appears in 3 different cells | Excel Worksheet Functions | |||
Combining & formatting cells with text - Excel 2002 | Excel Discussion (Misc queries) | |||
Text not copying as text from Word to Excel 2003 | Excel Discussion (Misc queries) | |||
details about vertical alignment in Excel cells | Excel Discussion (Misc queries) |