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.
3 Replies
Hello,
For information: On a French configuration, "mmm" gives "Sept"
On which Excel platform (Win, Mac, web, etc) and which channel you are? I can't reproduce
on
I have the same version as SergeiBaklan, on Windows 11. I do see sept:
It's really annoying.
