date format in Footer

[richardial]

Hi

I want the change the date format in my worksheet footer to display the month (long date format) e.g. 12-Dec-2008

Is there an easy way to do this?

Thanks
Richard

 

[Jon von der Heyden]

Hello Richard

This I belive is only possible if you enter it as a string, rather than use the DATE code. But with VBA you could use something like:

<font face=Courier New>    <SPAN style="color:#00007F">With</SPAN> ActiveSheet.LeftFooter = Format(Date, "dddd, dd mmmm yyyy")</FONT>