I copy data from a Word document into Excel. I then run a macro to arrange
this data in the correct format for users.

One of the column's contains dates, but instead of the / separator they are
separated by a .

Eg.
31.12.02
02.10.02

I use the following to replace them:

Range("F2:F" & Range("F65536").End(XlUp).Row).Replace ".","/"

And get:
31/12/02
10/02/2002

Is it something to do with the US date format or am I missing something
really easy?

Thanks in advance.

Gareth

NB
My PC date settings are dd/mm/yyyy