@GeertGB not sure if you are on the MacAdmins Slack but if you are
this is the thread
Basically Apple switched the data it writes to the AppleLocale key in your users' .GlobalPreferences domain.
I opened an Apple FB and it is "working as intended" Apple says, they say that no app should be getting the region from AppleLocale in .GlobalPreferences and instead use Swift/ObjC APIs.... well I guess Microsoft didn't get the memo!
So in your case if you are using English US for the language and Netherlands for the region, if you run this command:
Code:
defaults read .GlobalPreferences AppleLocale
You'll likely get this as the result:
en_US@rg=nlzzzz
If you were on Ventura or earlier, it'd be:
en_NL
So for now, until MS fixes how they are getting regions, you can revert to the old format, run this in Terminal as the current user (
not root):
Code:
defaults write .GlobalPreferences AppleLocale en_NL
Relaunch Excel and it should realize where you are and give you proper date formatting and unit separators