Thank you, Dave and Barb. Yes, this did work.

But what if the downloaded dataset was in xls rather than csv or txt and had
dates in non-DMY format? Would it be good to first export in csv format and
then import it back in, using the text to column wizard?

Thanks again.

--
Maki @ Canberra.AU


"Dave Peterson" wrote:

The bad news is that by the time you open the file in excel, some of the data
will be treated as text and some of the data will be treated as a date--but it's
the wrong date.

I'd rename the .csv file to .txt and open the text file. Then I'd see the text
to columns wizard and I could choose date and mdy in that wizard.

After the data is brought in as the correct dates, I can reformat the cells to
display whatever I like.



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

--

Dave Peterson