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.