Decimal Alignment

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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/formula.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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I indent a decimal aligned column from the margin? 1
column alignment 2
Word want multiple lines in Word Footer - with different formats 1
alignment with decimals & % sign 6
How do I center numbers in a cell, but align by decimal? 2
Aligning decimals in Excel ... 1
text alignment 1
Center on colon 3

Back
Top