"How To Excel" Mini-Tutorials by TheExcelAddict.com "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. Here's how: 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)