day/month/year date in excel

How do I change excel's date formatting so that when it opens up a CSV file with dates in day/month/year format, it shows up correctly in the date format? Currently, all dates with days over 12 are fine, but equal to or less than 12 excel is reformatting the day data into the month place.