Hi,
Format the dates to dd/mm/yyyy

Highlight the dates

Format Cells Number tab Date choose the one you need

If it is not in there go to Custom and put dd/mm/yyyy in the space
provided under Type.

HTH.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=381899