Re: insert a range of date

Yes. By using "(" you make it a text entry. That will override any
formatting and insert a US style date.

Leave out the test or use

Worksheets("Sheet1").Cells(3, 11).Value = "(" & format(Date,"dd mmm yyyy") &
")"

But you should realise that this last option makes it text so you can't use
it as a date for any further calculation

--
Kind regards,

Niek Otten

"Lynn" <moley_cruz@xxxxxxxxxxxx> wrote in message
news:1133798494.186926.244630@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> any clues?
>


.