Why some ZIP codes only have 3 or 4 digits in my Excel Spreadsheet?
Many ZIP codes start with 0 or 00. They do appear correctly in our database. But if you import them into another program as numbers rather than as text strings, your program may not display any leading zeros. Import them as text strings instead. If you’re viewing them in Excel, format your zip code field as ‘00000’ in order to see all five characters.
Related Questions
- If I use Excel, another spreadsheet, my Mac, or WebCT to manage grades and only want to use MMS to submit my final grades to the Registrar, how can I transfer my grades into MMS?
- Why some ZIP codes only have 3 or 4 digits in my Excel Spreadsheet?
- Why do some ZIP codes only have 3 or 4 digits in Excel?
