If the value is in A1 Try =DATE(MOD(A1,100)+2000,TRUNC(A1/100),1)

format mmm-yy


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=544288