Q: I am working on an import file in Excel. Unfortunately, the zeros at the beginning of my zip code have been dropped. How can I correct this?
A: When you load a CSV file into Excel, it tries to determine the format of the data being accessed. Excel automatically recognizes the zip code as a number and, by default, removes the zero from the front of the number. To resolve the issue, you will need to do the following:
When you have completed your work, select File, Save As to save the file in .CSV format for importing.