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.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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
I found the easiest way to handle this:
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.
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
Opening excel file in Numbers
