macOS 14 Sonoma - Numbers date format problem after upgrade
After upgrading to Sonoma, the date formats in my expense file (in Numbers) -which I update every month since 20 years- gone haywire! In Turkiye we use DD-MM-YYYY format. In Language&Regions settings, my region is Turkiye and Date format is DD-MM-YYYY.
But when I try format a cell in Numbers, choosing Date&time, only options available, now, is MM-DD-YYYY or MM/DD/YY or MM/DD/YYY. There is no DD/MM/YYY/ or alike format available to choose.
I created a custom date format and that's OK. But when I try to "format" a series of dates entered as "string", the format does not work. For example:
Date strings (in consecutive rows):
12/09/2023
13/09/2023
When I apply my custom date format they become:
09/12/2023
13/09/2023
and when I try make some calculations on them, like Cell1-Cell2 it gives 87 days :)))))
Very frustrating because it's not just looks :), I need correct dates to sort my expenses and etc.
Any solutions or comments are much appreciated...
Thanks
MacBook Pro 14″, macOS 14.0