Office 2007

I have inserted the date in the footer. The date format is 04/14/2010.
I want to change the format to April 14, 2010. Where can I change the
date format in the footer?

Thanks
Rita Brasher

Excel uses your Windows Regional Settings short date for this.

Unfortunately there is a limit on the format of that setting.

You cannot use that format in Windows short date.

You must use VBA to add a formatted date to a footer.

Sub DateInFooter()
With ActiveSheet
.PageSetup.CenterFooter = Format(Date, "mmmm dd, yyyy")
End With
End Sub

Sub Date_In_AllFooters()
Dim WS As Worksheet
For Each WS In ActiveWorkbook.Sheets
WS.PageSetup.CenterFooter = Format(Date, "mmmm dd, yyyy")
Next
End Sub


Gord Dibben MS Excel MVP

On Wed, 14 Apr 2010 09:22:13 -0500, Rita Brasher
wrote:

Office 2007

I have inserted the date in the footer. The date format is 04/14/2010.
I want to change the format to April 14, 2010. Where can I change the
date format in the footer?

Thanks
Rita Brasher

Forgot to mention.

You could always type the date into a custom footer.


Gord

On Wed, 14 Apr 2010 15:09:21 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Excel uses your Windows Regional Settings short date for this.

Unfortunately there is a limit on the format of that setting.

You cannot use that format in Windows short date.

You must use VBA to add a formatted date to a footer.

Sub DateInFooter()
With ActiveSheet
.PageSetup.CenterFooter = Format(Date, "mmmm dd, yyyy")
End With
End Sub

Sub Date_In_AllFooters()
Dim WS As Worksheet
For Each WS In ActiveWorkbook.Sheets
WS.PageSetup.CenterFooter = Format(Date, "mmmm dd, yyyy")
Next
End Sub


Gord Dibben MS Excel MVP

On Wed, 14 Apr 2010 09:22:13 -0500, Rita Brasher
wrote:

Office 2007

I have inserted the date in the footer. The date format is 04/14/2010.
I want to change the format to April 14, 2010. Where can I change the
date format in the footer?

Thanks
Rita Brasher