Excel is not recognizing the dates correctly, I have a column of dates in below format. the middle number 12 is the month and the first number are the dates.
04-12-2016
15-12-2016
12-12-2016
20-12-2016
01-12-2016
01-12-2016
29-12-2016
30-12-2016
22-12-2016
30-12-2016
Excel takes the first number as the month, and the second number as the date, no matter what I do to change in the date format with the 'Format Cell' option. also I tried Text to columns but the same thing happens, How do I make sure that excel recognizes the middle number as the month and the first number as the date???
Bookmarks