padmaster Wrote:
Sorry, the code is part of the macro....this macro is to convert a
excel file into a csv file and it is the dates within the files tha
are being changed from a UK format to a USA one...

Any help is appreciated....
Paddy


Sorted !!!

Range("c:c").NumberFormat = "dd/mm/yyyy"

Where c:c is the range

This ensures the format is correct in the macro...

Thanks for all your help

--
padmaste
-----------------------------------------------------------------------
padmaster's Profile: http://www.excelforum.com/member.php...fo&userid=3643
View this thread: http://www.excelforum.com/showthread.php?threadid=56199