Forum Discussion

Copper Contributor

Oct 15, 2020

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 function examples.xlsx170 KB

Diamond Contributor

Oct 15, 2020

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.

Walphi
Copper Contributor
Feb 03, 2021
SergeiBaklan
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
- SergeiBaklan
  Diamond Contributor
  Feb 03, 2021
  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.
Walphi
Copper Contributor
Oct 15, 2020
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
- SergeiBaklan
  Diamond Contributor
  Oct 15, 2020
  Walphi
  
  In English locale I see nothing wrong in the file, not sure about German localization.
  - Walphi
    Copper Contributor
    Oct 15, 2020
    SergeiBaklan
    here a screen shot ...
Walphi
Copper Contributor
Oct 15, 2020
SergeiBaklan
Sorry this view of the editor changes my typing:
Try it here again, added spaces
TEXT(1234567,899; " # . # # 0 , 0 0 €")
- Walphi
  Copper Contributor
  Oct 15, 2020
  here is the xlsx-file attached

Resources