Converting a 10 digit serial number to a date of mm/dd/yyyy
3344630400
If that's a Unix date stamp:
=DATE(1970,1,1)+A1/86400
Returns as a formatted date: 12/27/2075 (m/d/y)
If it's an Excel based date stamp:
=A1/86400
Returns as a formatted date: 12/25/2005 (m/d/y)
--
Biff
Microsoft Excel MVP
"Reenee" wrote in message
...
I have exported a report from my payroll software that gave me a 12 digit
serial number (not text) and that number is supposed to represent hire
date,
for example: 3344630400
How do I change this 10 digit number to read mm/dd/yyyy.
I have tried all I know please help
Someone told me that I had to divide this number by 864,000 + 2, but I
have
4000+ cells that need to be updated and I know there has to be a faster
way.
|