Date in Headers and Footers

W

Walt

In Excel Office XP, how can I change the default date in
a header and footer? The "&[Date]" command defaults to
mm/dd/yyyy. I would like something else.
 
W

Walt

Thanks for your help, Frank, but since it take the
Virtual Basketball Association ( :) ), I'll pass. If
Microsoft isn't going to spend the time to make it easy,
I won't waste my time programming something they should
have done. Thanks anyway.
-----Original Message-----
Hi
AFAIK this would require VBA. Would this be a feasible way
for you?
-----Original Message-----
In Excel Office XP, how can I change the default date in
a header and footer? The "&[Date]" command defaults to
mm/dd/yyyy. I would like something else.
.
Click to expand...
.
Click to expand...
 
G

Gord Dibben

Walt

You can change the default setting for this by Re-setting your Regional and
Language Settings in Control Panel.

Change "short date" format to what you want.

This is a global setting so all applications will be affected.

Gord Dibben Excel MVP

Thanks for your help, Frank, but since it take the
Virtual Basketball Association ( :) ), I'll pass. If
Microsoft isn't going to spend the time to make it easy,
I won't waste my time programming something they should
have done. Thanks anyway.
-----Original Message-----
Hi
AFAIK this would require VBA. Would this be a feasible way
for you?
-----Original Message-----
In Excel Office XP, how can I change the default date in
a header and footer? The "&[Date]" command defaults to
mm/dd/yyyy. I would like something else.
.
Click to expand...
.
Click to expand...
Click to expand...
 
Top