Assuming your fubared date is in column A, insert a new column
immediately to the right of that, and enter this formula:
=DATE(LEFT(A1,2)&MID(A1,4,2),MID(A1,7,2),RIGHT(A1, 2))

This parses the existing text string into arguments used by the DATE
function, which generates a date useable by Excel.