Saving Excel sheet in CSV fromat

A

Arthur J

When I save an Excel sheet in CSV format, some of the text
data is saved in a date format. Example 04-96 in Excel is
saved as Apr-96, However this is not a date and I want to
save it as entered. Is there a way to do this?

Arthur
 
J

jeff

Hi,

The cells have to be formatted as Text, but this may
mean you have to re-enter the data after formatting.
Simply converting now will just give the Excel date
serial value (ie 35156).

jeff
 
D

Dave Peterson

You sure that it's being saved incorrectly? Try opening your .csv file in
Notepad and looking.

I'm betting that the conversion happens when you reopen the .csv file in excel.

If you need to bring it back into excel, rename it to .txt.

When you open the file, you'll see the text to columns wizard and you can
specify that column as text.
 
Top