| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Excel mis-convert a string to a date
In a CSV file I have <<,"6 - 14",. On opening the file Excel 2007
strangely converts this to 14 Jun as a number. Clearly the CSV file said this was a string. Why does Excel think it knows better and give a poor user outcome. Regards Nick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert a string to a date? | Excel Discussion (Misc queries) | |||
| How to convert string to date | Excel Worksheet Functions | |||
| convert string to date | Excel Worksheet Functions | |||
| Convert Date to STring | Excel Discussion (Misc queries) | |||
| How to convert string to a date | Excel Worksheet Functions | |||
Threaded Mode
