EXCEL not display leading zeros

[Aasha]

Hello everyone .

In Excel how the cell data does not show the significant zero's in a table once they are entered , can you tell me how can i make the excel show the Leading Zero's , please help me thanks in advance

[ThoMas321]

If you use the option not to display 0, those in the column N will also disappear. instead ty this , In the Format Cell dialog box, instead of General, choose Custom (at the bottom), then type in what you want as the pattern (000).

[JonathanD]

Right-click / Format Cells or Format / Cells.

Select Category.

The right side of the box becomes then select different options depending on the format to apply.

The Preview allows you to keep checking your choice. Do not forget it and read it.

The Custom category allows for your own format. I suggest you begin by selecting a predetermined format, and then click Custom, then change the format according to the principles of the following table.

[Glenny]

When you want to display leading zeros for a fixed-length number, create a custom format with the same number of zeros (0) as digits that you want to display. For example, if you want to display a fixed-length number with five digits, create a custom number format with five zeros.


Use the 00000 format to display a number with five digits. When you use this format, the numbers that you type and the numbers that Microsoft Excel displays are listed in the following table.

To create a custom number format, follow these steps:

• On the Format menu, click Cells.
• Click the Number tab.
• Click Custom.
• In the Type box, type the custom format.
• Click OK.