Saving to Excel to a CSV file

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I am saving an Excel file to a CSV file. The colum of interest has mostly
string domain values (car models) such as Tundra, Yaris, Eos. However, a few
rows have pseudo numeric values such as 9-3 and 9-5. When car model 9-3 is
exported, the actual data value in the CVS file is 3-sep (a date). However,
I need this to be 9-3. What do I need to do to keep this as 9-3 (not a
date)?
 
Are you sure that the CSV file actually contains that 3-Sep string?

Try opening the file using Notepad--don't reopen the CSV file using excel.

If you do have to reopen the CSV file in Excel, rename it to *.txt, then use
File|open to open.

You'll be able to specify the type for each field--including Text for this one.
 
Back
Top