Date formatting in footer

C

computerguy

How do I change the format of the date option in the footer of a worksheet?
For example, currently it shows 8/9/06; how would I change it to Aug 8, 2006
or 9 Aug 2006 for example?.

TIA
 
G

Gord Dibben

You can make some changes in Windows Regional Settings to your short date format
which is what Excel uses for the footer date.


Gord Dibben MS Excel MVP
 
Top