Rob,

I have had the same thing. The only way I have been able to get round
it is to specify the format in VBa as follows

eg = Format(Date,"dd-mmm-yyyy")

I have used the "mmm" as if I use a 2 digit month it may still revert
to taking it as an american format ie 09/01/2006 becomes September
anyway, but doesn't happen from 09-Jan-2006

Not sure if there are other cures

Steve