I'm surprised you know quite an advanced formula like that (which I
don't understand) but are stuck with this! Just right click on the cell
with "38846" and select Format Cells. Select "Date" from the list and
choose the date format of your choice.
Ian
--
ianonline
------------------------------------------------------------------------
ianonline's Profile:
http://www.excelforum.com/member.php...o&userid=34279
View this thread:
http://www.excelforum.com/showthread...hreadid=540425