Zip Codes and Leading Zeros

[smellyrose121]

I have an address database and when I save it as a .csv file the leading zeros in the zip code column disappear. I know that I can format it as text, but when I resave it and reopen it, because its .csv it loses the format.
I think I need to change the column from integer to character, but I dont know how to do that. Any advice???

 

[jbeaucaire]

Your process is flawed. Save your workbook with all formatting as an XLS file. Then save a COPY of the sheet as a CSV. Always do your maintenance in the XLS version, then save...then save a CSV copy.

 

[smellyrose121]

I need to be able to import the csv file and have the zeros stay.