by "them" i mean all dates contained in the workbook.

when the raw data is imported it is in UK format (dd/mm/yyyy).

i have tried both the suggestions but neither works.



this is driving me mad :(


--
jarvo
------------------------------------------------------------------------
jarvo's Profile: http://www.excelforum.com/member.php...o&userid=18983
View this thread: http://www.excelforum.com/showthread...hreadid=395748