raypayette Wrote:
Dates are recorded as a number; today is 38915! The presentation is a
question of format, either in Excel or Windows (Local settings).
By the way the code you have posted does not seem to directly involve
dates.

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

Any help is appreciated....
Paddy


--
padmaster
------------------------------------------------------------------------
padmaster's Profile: http://www.excelforum.com/member.php...o&userid=36433
View this thread: http://www.excelforum.com/showthread...hreadid=561993