Opening CSV File

  • Thread starter Thread starter Carl Tribble
  • Start date Start date
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
 
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.
 
Back
Top