To display leading zeros, like in a zip code, create a custom number format. For example: Use 00000 for a five digit fixed-length number, or 000# for a variable length number prefaced by three zeros.
-
Right-click in a cell and select Format Cells.
-
On the Numbers tab, select Custom in the Category list.
-
In the Type box, type the custom format.
-
Select OK.
To blank zero fields in Excel, see Hide zeroes.
To display leading zeros, like in a zip code, create a custom number format. For example: Use 00000 for a five digit fixed-length number, or 000# for a variable length number prefaced by three zeros.
-
Control-click in a cell and select Format Cells.
-
On the Numbers tab, select Custom in the Category list.
-
In the Type box, type the custom format.
-
Select OK.
To blank zero fields in Excel, see Hide zeroes.
To display leading zeros, like in a zip code, create a custom number format. Excel for the web does not currently support creating your own custom formats, but the Excel desktop app does.
-
To open the desktop app, select Editing and choose Open in Desktop App at the top of the ribbon.
Don't have the Excel desktop app? Try or buy Microsoft 365.
