Turn date into text string

[Endered5]

So I want to store a date format, in this case its Swedish format "2020-11-17" as a text. This is 2020-11-17 when I have it as date format, see picture. However, when I click on General format, it becomes 44152. How is it possible to store 2020-11-17 as a general text?

I tried
Left(cell; 10) in order to get the whole 2020-11-17, but apparently it takes the 44152.

Any VBA code that could solve my problem? Any workaround?

 

[sandy666]

mm should work because of månad
weird,
maybe upper case will work?

 

[Endered5]

Why not?

I mean, i have two cells A1 and B1. A1 contains 2020-11-17 as general. B1 contains 2020-11-17 as date. Let's say that's the input, and the output I need is that I want both as general. It's a small step of a bigger problem, but difficult to describe in words.

mm should work because of månad
weird,
maybe upper case will work?

Even this is wierd

 

[sandy666]

check system date format

17/11/2020	=TEXT(TODAY(),"dd/mm/yyyy")
2020/17/11	=TEXT(TODAY(),"yyyy/dd/mm")
11/17/2020	=TEXT(TODAY(),"mm/dd/yyyy")
2020/11/17	=TEXT(TODAY(),"yyyy/mm/dd")