Not all dates are recognized as a date by Excel (Export from a system)

Dear,

I've exported a +- 400 rows out of a system with an date column.
Somehow, not all dates are exported the same way, some are recognized as dates, others not.

I would like to make a formula to fix these unrecognized ones or understand why these dates are not recognized, I need them to be recognized to be able to work/filter with.

Sample file of dates.xlsx


Hope you guys can help me out by looking into the sample file.

THank you in advance

Regards
Peter
The Netherlands.

Originally Posted by mcmahobt

1) Highlight the column
2) Data Tab on ribbon --> Text to Columns
3) Delimited With --> Next --> Next
4) Select the Date button and format based on the dropdown selection box
5) Finish

Dear Mcmahobt,

Thank you for replying, I've tried your solution but it does not convert the date fields into recognized dates.
The dates below show which are the recognized dates(GREEN) and which are not (RED)

02/24/2015 6:59 AM
02/25/2015 11:21 AM
02/27/2015 1:03 PM
02/27/2015 1:03 PM
02/27/2015 1:03 PM
02/27/2015 1:03 PM
02/27/2015 1:03 PM
10/13/2014 4:12 PM
2-3-2015
10/13/2014 4:13 PM
12-2-2014
02/13/2015 12:53 PM
02/26/2015 12:49 PM


Regards
Peter