Can't you format the cells using format "dd-mm-yyyy"?
Or in a macro: Selection.NumberFormat = "dd-mm-yyyy"?

With kind regards,
Ton Teun

--
Ton
-----------------------------------------------------------------------
TonT's Profile: http://www.officehelp.in/member.php?userid=4
View this thread: http://www.officehelp.in/showthread.php?t=66407
Visit - http://www.officehelp.in/archive/index.php | http://www.officehelp.in/index/index.ph