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.
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
Hi George,
Try this:
A2+B$1−2
Regards,
Ian.
Hi George,
Try this:
A2+B$1−2
Regards,
Ian.
Ian:
Very many thanks. I looked for a formula/unction, so didn't see the wood for the trees!
Excel dates in Numbers
