Hi Anita
Mark the column with the date.
DataText to ColumnsnextNextselect Date and choose M/D/YFinish

--
Regards

Roger Govier


"Anita" wrote in message
...
Sorry to ask this again but I've read the other posts and just can't
get this
to work.

I've imported some data from our database system and the dates come
across
in american format and the format is set to general in Excel. The
dates look
like this...

5/23/2007

How can I change it to read 23/5/2007.

Many many thanks in advance - if I can get this to work I'll be so
pleased!

Anita