Fix Excel regional format on MacOS

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=bgzzzz If you were on Ventura or earlier, it'd be: en_BG

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_BG

Relaunch Excel and it should realize where you are and give you proper date formatting and unit separators