Date not sorting properly

I tire of this issue and so once and for all I am hoping someone can help me so that I don't have to always have to have this happen.

The first column has dates which are showing formatted at Date, 14-03-2012 as according to Excel formats offered. Instead of dashes - my list uses / between values which I assume is not a problem.

All of the data was pulled from the same source and so the date formatting should be right and yet when I filter according to date it doesn't work properly. I have tried "text to columns" before but I can never seem to get this to work as it should. It baffels my mind how this is still a thing in Excel which to me, should be a fairly basic feature that people want to use and yet MS has not properly addressed.

If someone could help me from inflicting any further personal harm due to prolonged frustration I would be more than grateful.

Thank you.

Peter

did you forget to turn on the DMY option in text2columns?

Hi Sandy. Well, I have done that before but it must be that I am not doing it properly.
Text to Cols, Delimited
Tab selected, Text qualifier *
Finish.
This isn't working. Not sure what all these things mean "text qualifier".
Peter

I am seeing a problem in my work. The dates are filtering correctly until a point where the date date changes from mm-dd-year to mm/dd/year. I downloaded everything from the same source so not sure why some dates have a hyphen and some a slash. I am thinking this can also be corrected using "text to cols".
Again, for professionals these things are simple but for the average guy MS should simplify the whole things.

Peter

I went back to the start and notice that when I did the "text to col" the end result shifted some dates to left or right alignment with left alignment showing dashes and right alignement showing hyphens. Ugh!
Peter

Oh boy! I realized I was choosing MDY instead of DMY. Such a silly mistake.

I think it works. Thanks you all for your help on solving this for me.

Peter