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

Convert serial numbers in Numbers to date format

I have an Excel file that was converted to Numbers and the dates are now Serial Numbers. How do I convert these numbers to a date format?

Posted on Aug 13, 2021 9:59 PM

Reply
Question marked as Best reply

Posted on Aug 14, 2021 1:12 AM

Hi Tireddad,


Try this:


Formula in B2: A2+B$1−2

Fill down.


Regards,

Ian.

2 replies

Convert serial numbers in Numbers to date format

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