Saving Excel sheet in CSV fromat

  • Thread starter Thread starter Arthur J
  • Start date Start date
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
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel CSV Files; Creating Of 3
Excel And Notepad 3
.csv Commas ? 2
CSV->Excel Data Problem 1
CSV file doesn't save "xEy" style number as text formatted data 1
Save as CSV not saving the same from Excel 2007 then in Excel 2003 1
how to resolve incompatibility of saving an excel to csv format 1

Back
Top