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.
I see that you are using the English Excel. This error occurs in the German version of Excel. The TEXT function is named equal, the format of strings is different. Please see my last comments here from today.
BR Walphi
Sorry. but I can't check - in English version it works, but in German one most probably format texts like "0,000.00" are to be manually adjusted to German locale. I don't know it's specific.