Opening CSV File

C

Carl Tribble

I am using Excel 97 and opening a CSV file that includes a column that is
always text and always enclosed in double quotes. Somethimes this text is
text that could be interpreted as a date ("10/1" for example). When I open
the file, Excel always changes these values to date values. How can I
prevent this? As stated, I am already enclosing the value in double quotes
when I create the CSV file, but Excel seems to ignore them.

Thanks in advance!
-Car
 
D

Dave Peterson

Maybe you can gen remove the double quotes when you generate the text file and
use an extension of .txt.

Then when you open the file, you'll see the text import wizard. You'll be able
to choose the format for each field--including text for this 10/1 field.
 

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

Excel parsing unicode csv file 2
Missing double quotes when opening .CSV file from notepad 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel CSV Files; Creating Of 3
CSV & open by excel 7
problem exporting to CSV 1
Saving to Excel to a CSV file 1
CSV file opening as a text format 1

Top