CSV File

  • Thread starter Thread starter Rainman
  • Start date Start date
R

Rainman

I am working in AutoCad. I create a CSV file from AutoCAD. When I open it in
Excel 2002 some of the fields have a date format (08-Aug) instead of the
format intended (8-139). It seems any number that is under 100 (eg. 8-98) is
switched to the date format. I tried format cells using different options but
I don't get the format I want. Any ideas?
 
You could try importing the data via:
Data|get external data

And you'd be able to specify the type for each field--use text for these.

Or you could rename the .csv file to .txt
then use File|Open to open the .txt file.

Then you would see that same wizard.
 
File|Open text file will open the import wizard...
Make you choices...

Select the type as TEXT for the fields you want...
 
Back
Top