Swapping symbol "." for "/" without changing the date format

Heya,

I'm downloading some data from the system and I need to change the formatting from dd.mm.yyyy (downloaded as text) to dd/mm/yyyy (formatted as date).

I'm using code as below, but for some reason it's swapping days and months around (dd.mm.yyyy becomes mm/dd/yyyy)

Is there any way to do it?

Please Login or Register  to view this content.

Thanks,
Al

If you're OK with a formula:

=SUBSTITUTE(A1,".","/")+0

and format cells as date.

Please Login or Register  to view this content.