| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting a 10 digit serial number to a date of mm/dd/yyyy
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the serial date to a dd/mm/yyyy format | Excel Discussion (Misc queries) | |||
| Dates converting to MS serial number | Excel Discussion (Misc queries) | |||
| Converting Day, Date Month Year format to MM/DD/YYYY | Excel Worksheet Functions | |||
| converting 8-digit number to date | Excel Discussion (Misc queries) | |||
| Serial number of Date | Excel Worksheet Functions | |||
Threaded Mode
