Excel: Methods to Automatically Add Zeros After a Number

ID: Q74523


The information in this article applies to:


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 ##",000,000".

    This format will display the number 45 as "45,000,000" 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 "Type numbers with fixed decimal places" topic, and then click Display.


REFERENCES

"Microsoft Excel User's Guide, Book 1" version 4.0, page 220
"Microsoft Excel User's Guide, Book 2" version 4.0, page 191
"Microsoft Excel User's Guide" version 3.0, pages 188 and 551
"Microsoft Excel Reference Guide" version 2.1, pages 321-326 and 584

Additional query words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 5.00c howto spreadsheet


Keywords          : 
Version           : 
Platform          : 
Issue type        : 

Last Reviewed: March 22, 1999