I want a cell to display the current date and some string in addition to it. All formatted as a string e.g.
12.02.2020 My, Name _______ I tried to use
TEXT() but the formula
=TEXT(TODAY();"dd/mm/yyyy")& "; My, Name _______" does yield a
VALUE!-Errormessage. I think it is because my excel isn't interpreting my formatting in this case
"dd/mm/yyyy" the right way.
I use Office 2016.
The solution was as suspected in my local settings. My excel is set on english but the local settings are set to german. So the right formatting was