You may need to do "Text to Columns" and format as a date. I know it sounds
odd, but it works.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Maki" wrote:

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