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