Converting a 10 digit serial number to a date of mm/dd/yyyy
Rather than 864, do you mean 86400, Shane ?
86400 is 24 * 60 * 60, so is the number of seconds in a day.
--
David Biddulph
"Shane Devenshire" wrote in
message ...
Hi,
1. Enter 864 in a cell
2. Copy the cell
3. Select all the cells with the serial number
4. Choose Edit, Paste Special, Divide
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"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.
|