How do I use long date format in a header or footer?

G

Gord Dibben

You don't.

Excel defaults to short date.

You can achieve a modicum of alteration in Windows Regional Settings but not
like Thursday, November 16, 2005

To get that you would need a macro.

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

Alternative.................

Assume you have date formatted to Thursday, November 16, 2005 in A1

Sub CellInFooter()
With ActiveSheet
.PageSetup.CenterFooter = .Range("A1").text
End With
End Sub


Gord Dibben Excel MVP
 
Top