Microsoft KB Archive/74523

{|
 * width="100%"|

Excel: Methods to Automatically Add Zeros After a Number

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0
 * Microsoft Excel for OS/2, versions 2.2, 2.21, 3.0
 * Microsoft Excel for the Macintosh, versions 4.0, 5.0, 5.0a
 * Microsoft Excel for Windows, version 7.0

-

SUMMARY
There are two ways to automatically add zeros after a number in a worksheet. Both methods are described below.

MORE INFORMATION
These methods only work for integers. Real numbers with significant digits to the right of the decimal will not be affected.

Method 1: To add zeros after the number, without changing the value of the entered number, use the following steps:


 * 1) In cell A1, enter a number such as 45.
 * 2) With cell A1 active, on the Format menu, click Cells, and click the Number tab. (In Microsoft Excel versions 4.0a and earlier, click Number on the Format menu.)
 * 3) Under category, click Custom, and create the following custom number format ##&quot;,000,000&quot;.

This format will display the number 45 as &quot;45,000,000&quot; in cell A1. Note that the value of the number is still 45.

Method 2: To add the zeros and change the value of the entered number:


 * 1) On the Tools menu, click Options, and click the Edit tab. (In Microsoft Excel versions 4.0a and earlier, click Workspace on the Options menu.)
 * 2) Select the Fixed Decimal check box (place a check mark in it). In the Places field, enter -6, and click OK.
 * 3) In cell A2, type a number such as 45.

This procedure will display the number 45 as 45000000 in cell A2. The value of the number is 45000000.

For more information about the fixed decimal feature, click the Index tab in Microsoft Excel version 7.0 Help, type the following text

  fixed decimals

click the &quot;Type numbers with fixed decimal places&quot; topic, and then click Display.