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:
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.