| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
prevent converting numbers with hyphens to dates
I have a csv file that includes a column that contains text in the format
1-2-14. These are not dates, they are text and must remain in that format. I have tried importing, pasting, everything I can think of (including the obvious cell formatting) with no luck. They are converted into dates and I can't get them back into the right format. Can anyone help? Thanks in advance Mike |
| 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
