Centering data is one thing you can use the Center icon just like your text.

Decimal point alignment is something else, use # to indicate optional
digits. You can see more examples in the table on my page
http://www.mvps.org/dmcritchie/excel...htm#cellformat

format, cells, number (tab), custom
#,###.??? instead of #,###.00
If you want to keep it away from the right border then include _)
which simply means include a space as wide as close paren..
or any other character
#,###.???_)_0
---
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

"ChSp" wrote in message ...
How do I decimal align a column of numbers and indent it so it is centered
under the column heading text, which is center aligned?