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

Similar questions

How do you convert a date to serial number in numbers? How do you convert a date to serial number in numbers?
1252 1
Recognizing Dates in Apple Numbers. I download my account information from my Credit Union, and for more than a decade I was using Excel. The big problem that I face is that the format that I am forced to download it in is CSV, but the credit union pust their date format like this: 01Jun2022 with no spaces, and I can't seem to find a way to parse that such quickly so that numbers can recognize it as a date and format it, and sort it as a date. Numbers only sees it as text. Is there a solution, or do I have to keep renting MS-Excel for the rest of my life?
597 2
date conversion from this xlsx format 07.30.2021 to this numbers 44407 Good morning, on an excel file I had the data separated by points (examples 30.07.2021 29.07.2021 27.07.2021) with the export in Numbers they became: 44407 44406 44404) who can help me to report them with understandable dates?
784 3

2 replies

Yellowbox

Level 7

21,807 points

Aug 14, 2021 1:12 AM in response to Tireddad55

Hi Tireddad,

Try this:

Formula in B2: A2+B$1−2

Fill down.

Regards,

Ian.

Tireddad55 Author

Level 1

5 points

Aug 15, 2021 4:22 PM in response to Yellowbox

Success.

Thanks Ian for taking the time to help me. Much appreciated.

Cheers

Paul

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

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 Account.

Learn more Sign up