Hiya,
I frequently import text files into Excel through macro's and have found
that moving onto Excel 2003 has resulted in the dates being reversed.
i.e 8th December 2005 08/12/05 being imported as 12/08/05. I have checked
the formatting in Excel and this does not appear to be the issue. It appears
that the data is 12/08/05 rather then the expected 08/12/05.
When I revert back to Excel 98/2000 everything works fine. I have tried
recreating the macros in 2003 which doesn't seem to solve the issue.
Any thoughts / ideas appreicated.
Thanks
Simon
Bookmarks