Format date in header
The only way to custom format a date in a header or footer is by VBA
Sub add_date_header()
ActiveSheet.PageSetup.LeftHeader = Format(Date, "mmmm dd, yyyy")
End Sub
Gord Dibben MS Excel MVP
On Fri, 15 Jan 2010 06:00:01 -0800, Sammie
wrote:
I use the date button to insert the date in the spreadsheet header &[Date] ,
and I want to change the format of the date from 1/15/2010 to January 15,
2010. How do I do that?
Alternatively, what's the format for 15-Jan-2010?
|