How do I change date format in excel footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

the format dd-mm-yy would be more convenient for me and my colleagues. is
there a way to do that? thank you.
 
Hi
only possible with vBA directly inserting the date in the required
format. There's no build-.in way to achieve this
 
If you change your Windows>Control Panel>Regional and Language Settings Short
Date format to dd-mm-yy Excel will use that setting.

Note: this would be a global setting for Short Date.

Otherwise, Frank's suggestion re: VBA is the way to go.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Preserving date format 1
date format 1
Conditional formatting of date-cell - 2007 5
How do I delete merged cells in Excel without deleting the final d 5
Weird date format problem 2
Wrong date format in header 1
Changing date format in a footer 3
WHY DOES DATE FORMAT CHANGE IN COLUMN 1

Back
Top