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
|