How do I format the date in a footer?

[RBono]

Is it possible to display the date in a footer using the &[DATE] as a
alphabetic month instead of a numerical value?

[Jason Morin]

Try:

ActiveSheet.PageSetup.RightFooter = Format(Now, "mmmm")

HTH
Jason
Atlanta, GA

>-----Original Message-----
>Is it possible to display the date in a footer using the
&[DATE] as a
>alphabetic month instead of a numerical value?
>.
>