Wrong/different return of the weekday

Copper Contributor

Excel - German language

I have an older sheet, calculating the abbreviated weekday =Text(A1;"TTT"). 

The normal return was TWO letters, representing the workday, e.g. A1 = 2023-09-01 --> result Fr (for Friday).

But now, this formula returns THREE letters, in the example "Fri", for any reason. 

Has anyone a explanation?

 

Within the options --> language  ist set to German; all the formulas appear in German (no automatic change to English), and new formulas are also excepted in German language.

 

1 Reply

@Andre990 Never noted this but perhaps you can use a work-around like:

=LINKS(TEXT(A1;"ttt");2)