Change date format when importing from CSV
Option 3. Import it properly
Use DATA, Get External Data, From Text and when the wizard prompts you choose the appropriate DMY combination (Step 3 of 3, Under Column data format, and Date).
I have a CSV file where the date is formatted as yy/mm/dd, but Excel is reading it wrongly as dd/mm/yyyy (e.g. 8th September 2015 is read as 15th of September 2008).  
I know how to change the format that Excel outputs, but how can I change the format it uses to interpret the CSV data?  
I'd like to keep it to Excel if possible, but I could work with a Python program.