I am running Sage in the UK and when I export a report the dates are
exported as text.

I then need to change the format to "dd/mm/yy" - select the cell and
then press enter.

I have written some VBA code to automate this - but it does not work on
dates such as 25th March 2005 - because Excel thinks that 25 is the
month and 3 is the day.

Has anyone experienced a similar problem - Is there a solution?

Many Thanks,
Michael


--
michael.a7
------------------------------------------------------------------------
michael.a7's Profile: http://www.excelforum.com/member.php...o&userid=33027
View this thread: http://www.excelforum.com/showthread...hreadid=528494