If you don't want to change your regional settings, or enter the date
manually, you can use VBA to automatically update the date. One way:
Put this in the ThisWorkbook code module:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim ws As Worksheet
For Each ws In ActiveWindow.SelectedSheets
ws.PageSetup.LeftHeader = Format(Date, "mmmm d, yyyy")
Next ws
End Sub
Change LeftHeader to CenterHeader or RightHeader if desired.
If you're unfamiliar with macros, see
http://www.mvps.org/dmcritchie/excel/getstarted.htm
In article ,
"Radsri-" wrote:
how do I change the date format to September 7, 2005 on Excel when I use
custom header