Cannot enter dates in English (Australia) format
Hi,
I just spent about 1 hr with Microsoft 365 live chat and went around in circles without resolving the issue.
Here are the details:
– Using Mac Sonoma latest version with m3 max and excel (Microsoft 365)
– I have confirmed my Language and region settings are for Australia
I tried adding EXCEL to the customized Applications at the bottom but this didn’t change the results.
When I enter the Australia date format it reverts to USA format.
When dates start from ’13’ ie 13th June 2024 –> 13/6/24 they will display correctly because this would not work in USA format as 6/13/24 is an invalid date.
Hopefully someone out there has a fix for this.
Thanks!
Hi,I just spent about 1 hr with Microsoft 365 live chat and went around in circles without resolving the issue. Here are the details: – Using Mac Sonoma latest version with m3 max and excel (Microsoft 365)- I have confirmed my Language and region settings are for Australia I tried adding EXCEL to the customized Applications at the bottom but this didn’t change the results. When I enter the Australia date format it reverts to USA format. When dates start from ’13’ ie 13th June 2024 –> 13/6/24 they will display correctly because this would not work in USA format as 6/13/24 is an invalid date. Hopefully someone out there has a fix for this. Thanks! Read More