Hi everyone,
Just wondering if anyone knows how to change the date format around from an imported .csv file.
I live in Australia and we write our dates as dd/mm/yy but the file i have imported is mm/dd/yy.
I have tried to change it from the 'Format cells' using the Date and Custom categories but it still doesn't change it. The Sample view box in the 'Format Cells' when I have tried to change it still shows the original format I imported and it wont change.
I'm sure this has to do with the original document formatting but I'm just wondering if there is a way to swap the formatting around.

Thank you in advance, your efforts are much appreciated.

Regards