Formatting Date in Header & Footer
 

My header & footer was displaying as dd/mm/yyyy and I needed it to be
dd/mm/yy, I tried for ages to change it, checking out the message boards etc.
to no avail.

Guess what? You change the date format by going to the REGIONAL & LANGUAGE
SETTINGS in CONTROL PANEL on your pc. This then changes the way it displays
in Excel.

Hope this saves others some time.

Thanks Eliza.

Hope it helps others.


Gord Dibben Excel MVP

On Tue, 15 Mar 2005 12:09:03 -0800, "Eliza"
wrote:

My header & footer was displaying as dd/mm/yyyy and I needed it to be
dd/mm/yy, I tried for ages to change it, checking out the message boards etc.
to no avail.

Guess what? You change the date format by going to the REGIONAL & LANGUAGE
SETTINGS in CONTROL PANEL on your pc. This then changes the way it displays
in Excel.

Hope this saves others some time.