change date format

[Bisha]

I copy some data from an HTML page and save it on an Excel worksheet.
I need to change the date format from dd/mm/yy to mm/dd/yy but it doesn't
effect the format change .
Any idea why is this happening ?

 

[Peo Sjoblom]

It's probably text and it might have a trailing html character as well.
One way to go, use data>text to columns, click next twice, select date
and DMY and click finish

If that doesn't work you probably have a trailing html character,
try to delete it by selecting the range, do edit>replace and in the
replace what box hold down alt and type 0160 on the numpad,
leave the replace with box empty