This formula will give you the date value, but it will be in a different
cell. You could then copy the value back to the original cell.

=DATEVALUE(LEFT(A1,6) & "," & RIGHT(A1,5))

Tom