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.