Date sorting says sort A to Z

Hi

I've got a date field that originally was like this 22.05.2020. I tried all sorts to get it to display in 22/05/2020 display. I created another field derived from it using = text(A2, "DD/MM/YYYY" which worked, but it then wouldn't sort largest or smallest, it was still on A to Z.

I then looked up solutions and found one that says sort using sort and filter > largest to smallest, but it still says A to Z, what is the deal with this why won't it recognise a date when it sees it?

Very Annoying!

Thanks

Andrew

That's my point, sorry I never made it clearer. It just sticks on text type, even though I've applied date format to the whole column. The file is a download, maybe it's some format stuck in it, although why wouldn't Excel recognise it, especially after changing the data to a date format, then to a date type?

I already done the same thing effectively, using substitute(A2, ".","/")

Thanks that done the trick!

try this
=--substitute(A2,".","/")