You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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

Level 1

4 points

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

Top-ranking reply

Level 7

21,197 points

Posted on Aug 14, 2021 1:12 AM

Hi Tireddad,

Try this:

Formula in B2: A2+B$1−2

Fill down.

Regards,

Ian.

View in context

Similar questions