When I open an excel file in Numbers, that has a column of dates, the field is 5 digit numbers that are the Excel intrinsic format. How do I import it such that it displays the date rather than the number code?
MacBook Pro 13″, macOS 11.2
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
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
I found the easiest way to handle this:
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.
Opening excel file in Numbers
