This just gets rejected
Dim MyDate, MyLongDate
MyDate = "15 February, 2006"
MyLongDate = CDate(dd / MM / yy)
Steve
--
Steve1154
------------------------------------------------------------------------
Steve1154's Profile:
http://www.excelforum.com/member.php...o&userid=31550
View this thread:
http://www.excelforum.com/showthread...hreadid=512663