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