Yes. Generally if a data can be interpreted as a valid date using a US
format interpretation, it will be interpreted that way.

cdate is supposed to observe your regional settings and it appears to accept
period as a separator.

try
cdate("31.12.02")
cdate("02.10.02")

--
Regards,
Tom Ogilvy

Gareth wrote in message
...
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