In my footer, I've put &[Date] and it appears correctly as 4/29/07 for
today. How can I make it appear as "April 29, 2007"? I can't figure
out the place to change this format.

Thanks for any information.

jayray

Excel uses the Windows short date formatting for the footer date.

You can make some limited changes in Windows Regional Settings to your short
date format.

Not sure you can get April 29, 2007 format but give it a try.

Alternate solution...........use a macro.

Sub PathInFooter()
ActiveSheet.PageSetup.RightFooter = Format(Now, "mmmm dd, yyyy")
End Sub


Gord Dibben MS Excel MVP

On 29 Apr 2007 15:04:12 -0700, jayray wrote:

In my footer, I've put &[Date] and it appears correctly as 4/29/07 for
today. How can I make it appear as "April 29, 2007"? I can't figure
out the place to change this format.

Thanks for any information.