It worked for me (and has just done so again as I tried it on a different
machine). Are you sure you went though the steps listed in my post?

Did you definitely choose Date and MDY under Column Data Format at the last
stage of the Data/ Text to Columns operation?
--
David Biddulph

"AmyGG" wrote in message
oups.com...
David Biddulph wrote:

Data/ Text to Columns/ Delimited, at the end select Date, & choose the
format MDY.

That will convert your text to a date, and then you can format as
dd/mm/yy.
--
David Biddulph

Sorry, I tried this but the text stayed the same even after I
reformmated it to dd/mm/yy.