Hi Everyone.

I'm having problems with the Selection.Replace function.

I have a column with D.O.B's in the format DD.MM.YYYY e.g. 14.07.1987

I would like to replace all .'s with /'s i.e. to DD/MM/YYYY e.g. 14/07/1987

I have done this using a macro. All dates with days over 12 come over fine
e.g. 14th July. But all dates with days under 12 e.g. 12th July, 11th July do
not format properly.

24.07.1987 becomes 24/07/1987

11.07.1987 becomes 07/11/1987

i.e. the .'s have been replaced, but now the dates are wrong. They seem to
have become MM/DD/YYYY



Can anyone tell me how to correct this or tell me a macro from scratch.

Thanks!
Dave