I export dates from a program, which generates the dates in a mm/dd/yyyy format.
Problem is I'm in Australia and need it to be dd/mm/yyyy. I cannot change the export settings.
Is there a way I can convert the dates with a formula or similar? The problem I have is some dates end up...