Everything in a CSV is text. The conversion is occuring when you open it in
Excel.

As Duke said, open the CSV in notepad, wordpad or word and you should see
how it is being stored in the CSV. My post was to keep Excel from
converting it when it is opened in Excel. If this isn't the target
application to open the file, then your work is already done - now it is a
task of understanding.

--
Regards,
Tom Ogilvy

"MelissaM" wrote in message
...
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