Change the file extension to .txt and use the text import wizard to treat
the column as text (last dialog)

--
Regards,
Tom Ogilvy

"MelissaM" wrote in message
...
I need my file to be saved in CSV format (to import into another
application). When I format the zip codes as Text or Special(zip code),
they
are correct in XLS format, but when I open the file in CSV format they
switch
back to general.

Any solution? work around? Thanks so much for your help in advance!!

Melissa