Convert number to date

[XP]

Using Office 2007 on Win XP.

I'm mentally blocked at the moment. I have a number like: 396016747358

Which actually is a serialized value of an MS-Excel date and time. I need to
convert this number to its actual equivalent date/time using one or more
spreadsheet formulas.

Can someone help me out with that?

Thanks much in advance.

 

[Rick Rothstein]

Assuming by serialized value, you mean the decimal point was omitted and
that the actual value was 39601.6747358, then try this...

=--(LEFT(A1,5)&"."&MID(A1,6,15))

Note: The above, if correct, assumes you will never have any dates before
May 18, 1927 (the first date where the serial value was a 5-digit number).

 

[XP]

Thanks Rick, that does the trick; I kept messing around with "Date" and
"Time" functions.

Thanks!