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 [...]

Filed under: Microsoft Office Tutor | No Comments »