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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date format on import
Hi Ptoye,
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). If you use the Text Import Wizard, it's one of the options when specifying the data formats. The same is available using the .OpenText method in VBA. It's easiest to record yourself doing it to get it right. Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.co.uk |
Reply |
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 |