Hi Mark

One way would be
Copy your column of dates to another sheet
Use FindReplace (Ctrl + h) you could search for "th" (without the quotes)
and leave the Replace with field blank.
Repeat for "st", "nd", "rd" etc. and this should resolve those problems
Mark the range of dates, then DataText to ColumnsNextNextthen choose
Date D/M/Y Finish
..

Format the column with whatever date format you prefer, then Copy the column
and Pasteback over your original data.

--
Regards

Roger Govier


"MarkP" wrote in message
...
Hi,

I have a CSV file containing names, addresses, dates etc. Unfortunately
the dates have been entered in different formats eg. 10/11/2005, 25th may
2005 and 10.12.05. Is there a way of automatically changing them to
dd/mm/yyyy? The majority are in the format dd.mm.yy and at the very least
I would like to be able to change them to dd/mm/yyyy. There are about 4000
records so doing it manually is not an option.

Many thanks.