Make excel recognize foreign date format

You can add a new column after import and then convert the strings into an Excel datetimes with:

=DATE((MID(A1,7,4)),(MID(A1,1,2)),(MID(A1,4,2)))
 +TIME(MID(A1,12,2),MID(A1,15,2),MID(A1,18,2))

You can also add the fractional part if you need that resolution with:

=DATE((MID(A1,7,4)),(MID(A1,1,2)),(MID(A1,4,2)))
 +TIME(MID(A1,12,2),MID(A1,15,2),MID(A1,18,2))
 +VALUE(MID(A1,21,4))/(86400*10000)

These examples assume your string is in cell A1.

Related