Re: Excel Date Problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Gordon,

I also posted in the Microsoft.Public.Excel Group.

Got some good answers there too.
Main ones were
For VBA
HoldPrevYearDate = "Previous Year: " _
& Format(activeworkbook.worksheets("sheet99").range("a1").value, "dd
mmm yyyy")
For Excel
HoldPrevYearDate = "Date Reported: "&TEXT(A1,"dd mmm yyyy")


Best Regards,

Steve Wilson.

"Gordon Rainsford" <grbridgeREMOVETHIS@xxxxxxxxxxxxxx> wrote in message
news:1h8lh5l.1h2kddapplefkN%grbridgeREMOVETHIS@xxxxxxxxxxxxxxxxx
> Niek Otten <nicolaus@xxxxxxxxx> wrote:
>
> > Please don't post to multiple groups in separate messages.
> >
> > See answer in other newsgroup
>
> This is an unfortunate approach for those of us who don't know what
> other groups it has been posted to, but would have been interested in
> the answer to the question.
>
>
> --
> Gordon Rainsford
>
> London UK


.

Quantcast