M Michael Apr 30, 2009 #1 How can I make the date in the header apear as April 30, 2009 instead of 4/30/09?
M Michael Apr 30, 2009 #2 The date is in the header, not in a cell. I can format a cell easily, but the header is a whole other story.
The date is in the header, not in a cell. I can format a cell easily, but the header is a whole other story.
G Gord Dibben Apr 30, 2009 #3 Excel uses the Windows short date format in headers/footers. Very little formatting can be done with this. Couple of options...................... Either enter the date as text or use VBA to change the formatting to what you wish. Sub DateInFooter() With ActiveSheet .PageSetup.CenterFooter = Format(Date, "mmmm dd, yyyy") End With End Sub Gord Dibben MS Excel MVP
Excel uses the Windows short date format in headers/footers. Very little formatting can be done with this. Couple of options...................... Either enter the date as text or use VBA to change the formatting to what you wish. Sub DateInFooter() With ActiveSheet .PageSetup.CenterFooter = Format(Date, "mmmm dd, yyyy") End With End Sub Gord Dibben MS Excel MVP
