Forum Discussion
Excel 365: dd-mmm-yyyy now gives Sept instead of Sep
Excel 365: dd-mmm-yyyy now gives Sept instead of Sep — that breaks the documented format standard. Who thought this was a good idea?
They linked it to the Unicode locale standard. But it violates the formatting of "mmm". Work arounds for
USA locale format as [$-409]dd-mmm-yyyy → 05-Sep-2025
UK locale [$-809]dd-mmm-yyyy → 05-Sep-2025
AU [$-C09]dd-mmm-yyyy → 05-Sep-2025
NZ [$-1409]dd-mmm-yyyy → 05-Sep-2025
Problem is this is not portable. PLease can someone reach out to the devs and get this reverted? Formulas trying to pick out Sep & year from the string now will break.
6 Replies
Hello,
For information: On a French configuration, "mmm" gives "Sept"
Yes, they have changed it to the Windows operating system "locale". That is the problem. It should stay "mmm" means 3 letters.
On which Excel platform (Win, Mac, web, etc) and which channel you are? I can't reproduce
on
Windows 11 Pro, 24H2
Office 365 subscription
NZ localeI didn't check all locales, but yes, English NZ and South Africa give Sept. For English US, UK, India, Canada, Philipines we have Sep.
I'm on
and 365 both Beta and Current.
I have the same version as SergeiBaklan, on Windows 11. I do see sept:
It's really annoying.
