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) ...
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.
Btw, thanks for your answer
I was playing a little bit and there are interesting results on my side too:
A5=
1234567,89900
=TEXT(A5;"0,00 €") 1234,57€ =TEXT(A5*1000;"0,00 €") 1234567,90€ =TEXT(A5;"0,00")&" €" 1234567,90 €
