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?

 

[Fluff]

It's best to keep dates as dates, rather than text. However if you want them as text just format the cell as text & then insert the date.

 

[sandy666]

maybe use TEXT() function

 

[Endered5]

maybe use TEXT() function

It would still not work...

 

[sandy666]

in swedish year is Å

 

[Endered5]

It's best to keep dates as dates, rather than text. However if you want them as text just format the cell as text & then insert the date.

Yes, but in this occasion I unfortunately have one cell as general (2020-11-17) and the other as date (2020-11-17 but gives 44152 as general). I can't format the cells as text and then insert the date,

Is there any way or workaround?

 

[Endered5]

in swedish year is Å

Still not working. I think it still should be yyyy, since I have english version of excel?

 

[sandy666]

but system date is swedish
i see formula but don't see the result of this formula
and not 3 x å but åååå (4)

 

[Fluff]

I can't format the cells as text and then insert the date,

Why not?

 

[Endered5]

but system date is swedish
i see formula but don't see the result of this formula
and not 3 x å but åååå (4)

ohh i see. forgot one å. The wierd part is that i get 00 instead of 11