John

Excel gets its footer date format from your Operating System Regional Options
short date settings.

You might be able to change that to your desired format of dd-MMM-yy.

I entered that format in my regional settings and I still get dd-mm-yy so
don't know how you would make out.

It would be a global setting and affect all programs and all worksheets.

Alternative would be to enter a formatted date in a cell and use that cell as
the date in your footer.

This would require a macro to set all sheets.


Gord Dibben Excel MVP


On Thu, 8 Dec 2005 15:09:02 -0800, "John"
wrote:

I have entered a date in a worksheet footer. I would like to change its
format from the default of dd-mm-yy to dd-MMM-yy. How can I do this ? Can I
change the default date format for all worksheets ?
TIA