Inside Microsoft Excel

Keep your number’s leading zeros (2000/2002/2003/2004/2007/2010/2013)

Inside Microsoft Excel

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:

  1. Select[…]

Subscribe to Inside Microsoft Excel

(get full access to archives and more)