Numbers is only offering the American date orders, not European ones.

New MacBook Air (late 2024) with Sequoia 15.1.1

Problem: Numbers is only offering American style date numbering - with the month in the middle - and all the versions of that.

I am in Ireland, and we use the European method of DD/MM/YYY and versions of that.

Even when I type it in correctly Numbers is "correcting" my dates to the American version.

It happens in numbers documents that I brought over from my old Mac, that I use regularly.

It also happens to newly created documents.

It is extremely annoying and very confusing.

I have changed the System Setting / General / Language & Region to Ireland and 19/08/2025

I have also tried fixing it in the individual numbers documents: File / Advanced / Language & Region where it appears as I would expect the dates to appear for a European document.

Then I enter a new date in a cell and it reverts to 02/13/2025, even though I just typed it in as 13/02/2025.

I'm so frustrated that I am considering paying for excel!

Apparently looking at the related issues here. This has been a problem for a couple of years.

Does anyone know a permanent fix, or if there is a fix on the way, or should I just abandon Numbers?

Hopefully,

Claire - Small business owner in Ireland