Excel dates in Numbers

I have received a .xlsx Excel file. It opens in Numbers, but dates are rendered as integers.

This is the only such failure of translation I have encountered.

Presumably, the problem lies at the originators end (?). If I can't persuade them to format the dates appropriately - they claim they appear in a date format, but I suspect they are just text (?) - how can I transform them to a date format at my end?

Thank you

iMac 24″, macOS 11.6

Posted on Sep 28, 2021 3:04 AM

Reply
2 replies

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.

Excel dates in Numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.