Thanks for your response.

I tried saving the file as .txt and then opened that file up again (treating
the column as text). That worked, but I still can't saved the file as a
..csv...it converts the column back to general.

Melissa

"Tom Ogilvy" wrote:

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