by Kara Hiltz
If you need to enter the Zip code 02364 in your Excel spreadsheet, you’ll probably throw your hands up when Excel automatically changes the value to 2364. Your Zip code must have five digits, but by default Excel doesn’t display leading zeros.
Here’s the solution: Create a custom number format with five digits. This custom format forces Excel to display leading zeros.
To create a custom number format that keeps leading zeros intact: