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

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

On Thu, 10 Aug 2006 16:50:18 -0700, "computerguy"
<computerguy394-(E-Mail Removed)> wrote:

>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
>