office365 Excel and TEXT() formatting

The TEXT function seems to be broken on Office 365.

I downloaded from the above link using the link of Download Excel TEXT function examples, and this is what this worksheet from Microsoft looks like, completely broken:

enter image description here

You could complain to Microsoft on the Feedback Hub.

As a workaround, you could use the functions YEAR, MONTH and DAY.


Uh, it's locale dependent. I'm using Czech locale, thus I cannot use the default English TEXT() function, but Czech locale one HODNOTA.NA.TEXT():

=HODNOTA.NA.TEXT(B2; "ddd")

Comming from LibreOffice on Linux, this is really big difference for me.