Your Welcome. Glad you got it working.

--
Regards

Sandy

Replace@mailinator with @tiscali.co.uk


"Sami82" wrote in
message ...

Hi All,

Thank you so much for your help, I worked out that by selecting the
date format with the * it doesnt swap the dates around.

:)


--
Sami82
------------------------------------------------------------------------
Sami82's Profile:
http://www.excelforum.com/member.php...o&userid=27111
View this thread: http://www.excelforum.com/showthread...hreadid=466607