I have data in excel which I suspect is in text format and which is dd/mm/yy.
I want to convert it to date format mm/dd/yyyy.
I've done this before successfully, but I don't remember how.
Please help.