| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date format on import
How can I force the text input mechanism to use European
format rather than American format on a date? It's in a single cell only, not an entire column. As far as I can see, if the date is a valid mm/dd/yy date it's imported in American format, otherwise if it's valid in dd/mm/yy format it seems to import in European format (but I've not tested this much). Not much use around this time of the year! About time that MS learned about locales IMHO. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
| How to change the date format from import link? | Excel Discussion (Misc queries) | |||
| Date format problems after csv import | Excel Worksheet Functions | |||
| Cell format with Data Import (date appearing as text) | Excel Discussion (Misc queries) | |||
| Change a date in text format xx.xx.20xx to a recognised date format | Excel Programming | |||
Threaded Mode
