Forum Discussion
in excel office 365 TEXT function does not work correct
TEXT function has a bug in office 365. How can that be fixed with workaround and/or reported to Microsoft? Example: (viewing problem, please remove all spaces in "..." or see attachment of formula) ...
Why don't you attach the file directly to your post?
As for the formula it is
in Excel for Microsoft 365, but I'm not sure which result do you expect.
SergeiBaklanSorry this editor is really ....
If I change from German language to English the view is different, especially th eformula.
The xlsx-link is working, to get the excel sheet please remove the last char ")" in your browser
In English locale I see nothing wrong in the file, not sure about German localization.
here a screen shot ...
Because the format string is in double quotes it will not be 'translated' into a German locale string.
You have to change the formulas manually. Change every , to . and every . to ,.
=TEXT(A4;"#.###") =TEXT(A5;"0.000,00") =TEXT(A6;"#.") =TEXT(A7;"#.###,0.") =TEXT(A8;"0,0..")BTW, I did not get an #WERT! error - just wrong formatting.
