Opening excel file in Numbers

I found the easiest way to handle this:

1. Download and install Excel for Mac from the Mac App Store. It doesn't require a license to display Excel files, just to create or edit them.
2. Open your Excel file in both Excel and Numbers.
3. Copy the date column in Excel and paste it in Numbers.

Hi handlewithcare

See the solution by Hiroto in this discussion:

https://discussions.apple.com/thread/4993043?answerId=25227162022#25227162022

In order to get date in B1 from date serial number in A1, set the formula in B1 to:

=DATE(1904,1,1)+A1

Please call back with questions.

Regards,

Ian.

That may be because you are opening an old Excel format. In Excel try saving as .xlsx. Or if you don't have Excel open the file in LibreOffice (the free Office clone) and save it as .xlsx from there. Numbers should then recognized the dates as dates.

SG