Date in Headers and Footers

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

 

[Frank Kabel]

Hi
AFAIK this would require VBA. Would this be a feasible way
for you?

 

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

.

 

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

.