CSV File
 

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?

CSV File
 

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.

Rainman wrote:

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?

--

Dave Peterson

CSV File
 

File|Open text file will open the import wizard...
Make you choices...

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

"Rainman" wrote:

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?