How to Center Numbers and Have Decimals Line Up in Excel
ID: Q44737
|
The information in this article applies to:
-
Microsoft Excel for Windows, versions 2.x, 3.x, 4.x, 5.0, 5.0c
-
Microsoft Excel for Windows NT, version 5.0
-
Microsoft Excel for Windows 95, version 7.0
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:
- Select the cells to be centered.
- 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.
- 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.
- Click OK to save the new format and make the change.
To center data in a cell without aligning decimal places, do the
following:
- Select the range to be centered.
- 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.
- Under Horizontal, select the Center option and click OK.
Additional query words:
2.00 2.0 2.01 2.1 2.10 2.2 2.21 2.20 3.00 3.0 4.00 4.0 4.00a
Keywords :
Version : 2.x 3.x 4.x 5.00 5.00c 7.00
Platform : WINDOWS
Issue type :
|