Thread: CSV File
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rainman Rainman is offline
external usenet poster
 
Posts: 1
Default 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?