Importing Zip Codes


Exported zip codes from another program and imported them into Goldenseal small business software. The ones in New England have truncated Zip Codes - the initial 0 is missing.


This is a problem in Microsoft Excel. If you open the export file in Excel, it "tidies up" the numbers and removes the leading zeros.


If you exported from a program other than Excel, just don't open the file in Excel.

If you need to open the file in Excel, change the number format for the zip code cells to "00000". That will keep all the digits, even if zero.


Entered 1/17/03 by Dennis. Updated 11/12/2010.