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.

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.