"How To Excel" Mini-Tutorials|
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"
How To Center Numbers And Still Keep Decimals Aligned
Do you find yourself sometimes wanting to center your numbers in
a column but when you do the decimals are not lined up? Here's a
tip that I use anytime I need to perform such a task. The numbers
aren't exactly centered but it gives the illusion that they are.
- Select the cells you want to center.
- Select Format, Cells and click on the Number tab.
- In the Category field, select Custom.
- If the selected cells already have a number format, that
format code will appear in the Type field. Otherwise, the word
'General' will appear and you'll either have to select a
format from the list of formats or enter one yourself.
- Once you have the desired number format in the Type field,
type two or more 'blank spaces' following the code. NOTE: If
the number format is a two-part format $#,##0_);($#,##0),
you'll have to add spaces after each section $#,##0_) ;($#,##0) .
- Click OK to see if the format gives you the desired result.
Add extra spaces to adjust.
Why not print (CTRL+P) this tip and share it with your friends and associates?
Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.|
Copyright © 2003 All Rights Reserved by Francis Hayes (The Excel Addict)