Formatting Date in Header & Footer

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date in footer 3
date format 1
Wrong date format in header 1
Excel 2002: How to make the date format uniform ? 1
Date format in Header 7
Excel 2007 text import as text not date 3
Header/Footer Date Format 2
Change date format in Excel footer 2

Top