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)
=TEXT(1234567,899; "# . # # 0 , 0 0 €")
excel 365: #WERT! (sorry, German version, no idea how that is called in English)
excel 2013: 1.234.567,90 €
https://support.microsoft.com/de-de/office/text-funktion-20d5ac4d-7b94-49fd-bb38-93d29371225c?ui=de-de&rs=de-de&ad=de
In this link above there is this link (http://download.microsoft.com/download/6/A/8/6A818B0B-06F4-4E41-80DE-D383A3B89865/TEXT%20function%20examples.xlsx) ) to TEXT examples which now don't work
14 Replies
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.
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.
Sorry this view of the editor changes my typing:
Try it here again, added spacesTEXT(1234567,899; " # . # # 0 , 0 0 €")
here is the xlsx-file attached
