Edit footer Date

[kristof]

How do I change the date format when I select the auto date input. I would
like to have 21 May, 2008

istead of the default that is listed now? Tried to edit it but this does not
work.
Txs

 

[JE McGimpsey]

How do I change the date format when I select the auto date input. I would
like to have 21 May, 2008

istead of the default that is listed now? Tried to edit it but this does not
work.

IIRC, the date format is set by your system date settings, and it's
limited to a small number of choices.

If you're using XL04 or previous versions, you can use a macro:

Public Sub DateInFooter()
ActiveSheet.PageSetup.LeftFooter = Format(Date, "dd mmm, yyyy")
End Sub

(your example is ambiguous as to whether it should be mmm or mmmm).