Excel preserves leading zeros when saved in CSV format. You should see this
if you open the file in Notepad. Opening the CSV in Excel is not a good
test because, as IanRoy said, Excel strips off leading zeros.

--
Jim Rech
Excel MVP
"vkushnerov" wrote in message
...
|I have an excel spreadsheet that I need to convert to a .csv to import.
One
| of the columns is the zip code, including codes that start with 0.
However,
| whenever I convert it to .csv, it strips out the first 0 of the zip code,
| thus leaving a 4 digit code. Is there a way to fix this?
|
| Thanks!
|