Well here's the story:

I recently got a small program called dBoot, it'll save me having to keep going to my list's URL on etree to find out where my shows are stored and what-not. Now, on etree, I was able to export my list as a CSV file.

Problem:
Because I live in Australia, excel is set to automatically read Australian format dates and change those cells automatically to Date format. I use Excel 2007, so is there a setting to turn this off?

But the problem goes further, if I just set the other cells as Date format, no matter which way I go or property I choose, it won't change to Date format, it was stay as General. And General format in dBoot reads as something like 0001-01-01 (yyyy-dd-mm) and I don't want to have to go through each and every single entry (excluding a few) in there to change a date.

Any help would be much appreciated.

Nevermind, I fixed the problem. Had to change my systems date format around and then Import, then change it back. Found that through Excel Help. lol