Hi Group,

I have inherited a large spreadsheet full of payments
(about 5000 of them). Some dates are entered like so
01/01/04, 01/1/2004, 01.01.04, 01.1.2004.

Excel does not recognise the dates with full stops in
them. Is there a fast and efficient way for me to convert
and standardise all dates to dd/mm/yyyy?

Regards

Tony