Is there a way to change the date format of footers?

G

Gord Dibben

You can effect some small changes in Regional and Language Settings in Control
Panel.

Change the short date format.

For major changes you would need VBA code.

Sub date_footer()
ActiveSheet.PageSetup.RightFooter = Format(Now, "yyyy-mmm-dd hh:mm:ss")
End Sub


Gord Dibben MS Excel MVP
 
B

Bernard Liengme

The format is taken from your Regional Setting (found in Windows Control
Panel)
To override, use a macro such as
Sub MakeDate()
ActiveSheet.PageSetup.LeftFooter = Format(Date, "dd-mmm-yy")
End Sub
best wishes
 
Top