It will help if you know what date is represented by 3344630400. I am
thinking that it might be a serial date AND TIME but with the decimal point
omitted but it is difficult to say what it is without knowing what it
represents.

--
Regards,

OssieMac


"Reenee" wrote:

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.