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