| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
prevent converting numbers with hyphens to dates
Rename the csv file to .txt, then in Excel do File | Open and point to
the .txt file. This will automatically take you into the File Import Wizard, where you will be able to specify in the 3rd panel which field(s) you want to import as text (or dates etc). Hope this helps. Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting numbers to text | New Users to Excel | |||
| Converting Formula answers to numbers | Excel Discussion (Misc queries) | |||
| Converting numbers to date format from csv files | Excel Discussion (Misc queries) | |||
| converting dates into numbers | Excel Discussion (Misc queries) | |||
| micosoft excel dates entered but changed to sequencial numbers ho. | Excel Worksheet Functions | |||
Threaded Mode
