Thread: Dates Problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ianonline
 
Posts: n/a
Default Dates Problem


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