Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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
Question marked as Best reply

Posted on Sep 28, 2021 3:09 AM

Hi George,


Try this:


A2+B$1−2


Regards,

Ian.

2 replies

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