How to Center Numbers and Have Decimals Line Up in Excel

Article translations Article translations
Article ID: 44737 - View products that this article applies to.
This article was previously published under Q44737
Expand all | Collapse all

SUMMARY

In Microsoft Excel, you can center your data in a column on a worksheet so that the decimals appear to line up.

MORE INFORMATION

To give the illusion that your data is centered with decimals aligned, create a custom number format by doing the following:

  1. Select the cells to be centered.
  2. In Microsoft Excel versions 5.0 and later, click Cells on the Format menu, and then click the Number tab.

    In Microsoft Excel versions 2.x, 3.x and 4.x, click Number on the Format menu.
  3. In the Code box, type the following (without the quotation marks):

    "#.00 "

    Adjust the spaces following the number format to make the data appear centered according to the current column width.
  4. Click OK to save the new format and make the change.
To center data in a cell without aligning decimal places, do the following:

  1. Select the range to be centered.
  2. In Microsoft Excel version 5.0 and later, click Cell on the Format menu, and click the Alignment tab.

    In Microsoft Excel versions 2.x, 3.0 and 4.0, click Alignment on the Format menu.
  3. Under Horizontal, select the Center option and click OK.

Properties

Article ID: 44737 - Last Review: November 16, 2006 - Revision: 1.5
APPLIES TO
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0c
  • Microsoft Excel 5.0 Standard Edition
  • Microsoft Excel 4.0c
  • Microsoft Excel 3.0a
  • Microsoft Excel 2.10d
  • Microsoft Excel 2.1 Standard Edition
  • Microsoft Excel 2.01
  • Microsoft Excel 2.0 Standard Edition
Keywords: 
KB44737
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com