Use leading zeros in postal codes and other numbers
If you type a postal code such as 00345 into a cell, you will notice that the number is truncated to 345. Excel provides two types of custom formats to display leading zeros: one for fixed-length numbers, such as phone numbers and postal codes, another for variable-length numbers.
Do any of the following:
Display leading zeros in fixed-length numbers
Display leading zeros in variable-length numbers