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

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

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

On Wed, 16 Nov 2005 16:12:03 -0800, "Long Date Format in Excel" <Long Date
Format in wrote: