How can I get the date in my header to display: "September 9, 2004"

instead of "9/9/2004"


right now the custom header is: &[Date]




--
Thanks,
Steve (office 2000)

You'll have to use a little VBA.

Option Explicit
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Worksheets("sheet1").PageSetup.LeftHeader = Format(Date, "mmmm d, yyyy")
End Sub

Rightclick on the excel logo to the left of File (on the worksheet menubar) and
select view code.

Paste that code into the code window.

Adjust the worksheet name and .leftheader to what you want.

If you record a macro when you change the header, you'll see the syntax.

Steve Adams wrote:
>
> How can I get the date in my header to display: "September 9, 2004"
>
> instead of "9/9/2004"
>
> right now the custom header is: &[Date]
>
> --
> Thanks,
> Steve (office 2000)

--

Dave Peterson
(E-Mail Removed)

That works really neat, Dave. VBA is good stuff!

--
Thanks,
Steve


"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> You'll have to use a little VBA.
>
> Option Explicit
> Private Sub Workbook_BeforePrint(Cancel As Boolean)
> Worksheets("sheet1").PageSetup.LeftHeader = Format(Date, "mmmm d,
yyyy")
> End Sub
>
> Rightclick on the excel logo to the left of File (on the worksheet
menubar) and
> select view code.
>
> Paste that code into the code window.
>
> Adjust the worksheet name and .leftheader to what you want.
>
> If you record a macro when you change the header, you'll see the syntax.
>
> Steve Adams wrote:
> >
> > How can I get the date in my header to display: "September 9, 2004"
> >
> > instead of "9/9/2004"
> >
> > right now the custom header is: &[Date]
> >
> > --
> > Thanks,
> > Steve (office 2000)
>
> --
>
> Dave Peterson
> (E-Mail Removed)