Re: insert a range of date

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

<Leave out the test or use>

Leave out the text....

as you hopefully guessed already

--
Kind regards,

Niek Otten

"Niek Otten" <nicolaus@xxxxxxxxx> wrote in message
news:Ox$k7Zb%23FHA.2192@xxxxxxxxxxxxxxxxxxxxxxx
> 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?
>>
>
>


.

Quantcast