When you convert the .Csvf fiel from Text to Colum, there is an option "Delimited --> Next -->Date"
Under the "Colum Date Format" part of the small window, you need to select your computer date format and then excel will convert it to the correct format. The Csv file comes out in an american format.
Hope this explanation helps??
If you maybe need more help with your Csv file, you can also check the following link:
I basically did an excel template which automates the CSV data you get...
**[Advertisement removed in line with - Community Center Guidelines]