Footer date format
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 |
Footer date format
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 |
Footer date format
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 |
All times are GMT +1. The time now is 11:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com