A downloaded dataset has dates in American format, i.e. mm/dd/yyyy, whereas
my regional setting is dd/mm/yyyy.

It was downloaded in csv so currently the cells, those dates are in, are
formatted "General".

What's the easiest way to convert all mm/dd/yyyy dates to dd/mm/yyyy?

I thought this would be straight forward but couldn't find example in Help
file.

I'm using Excel 2007.

Thank you.
--
Maki @ Canberra.AU