Saving to Excel to a CSV file

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)?
 
D

Dave Peterson

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.
 

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

Adding data to MS Access from csv file 0
Problem formatting dates from CSV file 2
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
How to remove CSV file-saving warning 1
Merging from an Excel file with graphics 1
How to create a column of pseudo random numbers with probability ' 2
Possible to Combine reports to's to a single box? 0
VBA - exporting serial letters to single documents 0

Top