Highlight the column
Click on <Format<Cells<Custom and in 'Type' enter dd/mm/yyyy and click on
OK
Job done.

Regards.

Bill Ridgeway
Computer Solutions

"Suzanne Bond" wrote in message
...
I have text direct from a US system in a report, the text is a US date eg
01/30/2004. I would like to complete an aging report and need to find an
easy way to convert text 01/30/2004 to 30/01/2004 to allow excel to
recognise
this as a date.
I have around 400 lines of data to convert so dont want to have to do this
manually.

can anyone help??
Thx
--
Suzanne Bond