Date format in excel 365 is in make as 5 digit number

How To
1

Hello to all, at first I saw all similar topics to solve the problem. But none of them helped.

I use excel 365 and OneDrive 365. I have date in format DD.MM.YYYY in excel. And yes, I check wether it is text or date format. It is date formatted.

Within Make I see, that the date is captioned as 5 digit number. I tried all of the variables, but without success. the date should be: 15.03.2025

obrázok
obrázok521×677 26.8 KB

obrázok
obrázok518×325 11.3 KB

obrázok
obrázok333×285 6.96 KB

Is here any solution? as I would like to work with the dates.

Thanks for the help