Hello there,
I’m not sure if I’m on the right place here with my question. If not, please excuse the circumstances.
I just installed Excel 2016 in English on my PC. It runs on a german Windows 10.
Excel does nearly all good in English, but for little things like the date-formatting I need to use the german-expression. I can’t use the English one, although everything else in Excel (including the other parts of the formula) are English.
For example, if I want to convert a date to a weekday I need to write the following:
=TEXT(WEEKDAY([@Date]); "tttt")
instead of
=TEXT(WEEKDAY([@Date]); "dddd")
because "tttt" is the german version of "dddd".
I saw that I can change the output language with the languagecode in [] but that doesn’t really solve the core issue of my problem.
Can someone help me with this? I really don’t know what I could do different.
Thanks alot for your help and kind regards
I’m not sure if I’m on the right place here with my question. If not, please excuse the circumstances.
I just installed Excel 2016 in English on my PC. It runs on a german Windows 10.
Excel does nearly all good in English, but for little things like the date-formatting I need to use the german-expression. I can’t use the English one, although everything else in Excel (including the other parts of the formula) are English.
For example, if I want to convert a date to a weekday I need to write the following:
=TEXT(WEEKDAY([@Date]); "tttt")
instead of
=TEXT(WEEKDAY([@Date]); "dddd")
because "tttt" is the german version of "dddd".
I saw that I can change the output language with the languagecode in [] but that doesn’t really solve the core issue of my problem.
Can someone help me with this? I really don’t know what I could do different.
Thanks alot for your help and kind regards