Date Format

[Dawn]

Can someone tell me how to change the format of the header/format date?
Currently its is printing out as 24-11-04 , would like it to be Nov 24, 2004

I went to the global settings and chose the format that I prefer but it
still will not change.

Thank you.

 

[Jim Rech]

It doesn't look as if Excel will write out month names even when such names
are specified under Control Panel as part of your short date format. MS
suggests using a macro to set the footer:

http://support.microsoft.com/default.aspx?scid=kb;en-us;161607