Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

convert date number back to date

I have a spreadsheet that has been exported from some other software and when I open it in Numbers the dates are all showing as the internal serial date number. Can this number is converted back to the date I can understand using a formula in Numbers? Thank you!

Posted on Oct 9, 2015 8:04 AM

Reply
1 reply

Oct 9, 2015 8:44 AM in response to ClydeHouse

ClydeHouse wrote:


I have a spreadsheet that has been exported from some other software


What is that "some other software" and what are the serial numbers you have?


If the other software happens to be Excel then you could try this:


Enter the Excel "start date" in a Numbers cell: either 1899-12-30 or 1904-01-01 depending on the date system used.


Then add your serial number to that.


User uploaded file


SG

convert date number back to date

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.