Footer date format
in [General]
|
Prev: Selecting only specific rows for a Sort
Next: directing a total to various cells dependent of its value
From: Rita Brasher on 14 Apr 2010 10:22 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
From: Gord Dibben on 14 Apr 2010 18:09 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 <rita.brasher(a)fedex.com> 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
From: Gord Dibben on 14 Apr 2010 18:12
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 <rita.brasher(a)fedex.com> >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 |