Keep Leading Zeros

If you work with product numbers, zip codes, or any number that starts with a leading zero you will probably want Excel to keep the leading zero visible.

By default when you type the product number 012345 into a number formatted cell Excel will drop the leading zero and show 12345. To keep the leading zero you can use a custom number format.

keep leading zeros

1. Right click the cell to custom format and select Format Cells

2. In the Category box select Custom

3. In the Type box enter a zero for each digit in your number. In this case I entered 6 zeros because my product number was 6 digits long.

4. Hit OK

leading zeros in excel

Also note: If you are using a Zip Code, Zip Code + 4, Phone Number, or Social Security Number that begins with a zero, Excel has built in number formats for these. You can access them by selecting Special instead of Custom in the Category box. Also make sure your Locale is set to English.

Leave a Comment

Automate Excel
Left Menu Icon