Change the cell format.

Format CellsNumber:

Catergory = Custom

Type = DD/MM/YYYY

If this doesn't work, it may be a case of changing your regional
setting, within control panel.


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=489468