hi treeantz. here are 2 methods you can try.
1. Text to column
i) select data in column A (eg. A1:A10)
ii) go to Data -> Text to Columns -> Delimited -> Next -> Next -> Date: DMY -> Destination: $A$1 (to replace existing. choose somewhere else if you dont wish to replace). -> Finish
2. Formula (provided it's always 2 digits for day & month)
=DATE(RIGHT(A1,4),MID(A1,FIND(".",A1)+1,2),LEFT(A1,2))
Bookmarks