It is already formatted into date format automatically as soon as I open the file. Basically I need to convert the day values into month data, and the month values into day data. Or I need tot ell excel to stop converting csv data automatically.