ExcelBanter - Can we change the format for pre set footers like date, time etc.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can we change the format for pre set footers like date, time etc. (https://www.excelbanter.com/excel-discussion-misc-queries/165063-can-we-change-format-pre-set-footers-like-date-time-etc.html)

Pavan

Can we change the format for pre set footers like date, time etc.

I would like to know whether we can change the display formats for preset
footers like date,time,etc. For e.g I want the date in footer to display as
06 Nov 07 instead of 11/6/2007. How can we do that?

All times are GMT +1. The time now is 10:49 AM.