| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File:1 and File:2 -- Double Files when Opening One File | Excel Discussion (Misc queries) | |||
| I saved file A over file B. Can I get file B back? | Excel Discussion (Misc queries) | |||
| opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
| I SAVED A FILE OVER ANOTHER A FILE IN EXCEL. THE OLD FILE WAS AN . | Excel Discussion (Misc queries) | |||
| i received a file that reads powerpoint document file file exten. | Excel Discussion (Misc queries) | |||
Linear Mode
