| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
importing csv
I periodically import .cvs files that contain data like
0000 00 00000 0 at various places in the file. I need to capture the correct characters in Excel. Because Excel insists on dropping leading zeros, I am forced to rename the file as .txt before opening it. I can then tell the import wizard to treat the data as text. Is there a better way? -- Gary's Student |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IMPORTING WORD DOCUMENT INTO EXCEL | Excel Discussion (Misc queries) | |||
| number of fields exceeds 256 when importing from a dbf file | Excel Discussion (Misc queries) | |||
| Importing data into excel | Excel Worksheet Functions | |||
| Importing text file | Excel Discussion (Misc queries) | |||
| How to import a path/filename when importing data into an XML list | Excel Worksheet Functions | |||
Threaded Mode
