Text Alignment in Excel Cells

[Guest]

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.

 

[David McRitchie]

Hi Eduardo,
See the table in
http://www.mvps.org/dmcritchie/excel/formula.htm#cellformat

0.????_);(0.????);0.????;@ [align on decimal point]