Well, I'd insert a column after your date-text-string column and convert it to an excel proper date using DKO's formula above, copy this new column and paste values to your original column, and then delete this helper column.
Then you can use Custom format if you don't see an option under Date that satisfies your demands.
Bookmarks