change date function format in footer

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

Guest

I would like to change the automatic date function in my footer to ie.
January 25, 2005 instead of 01/25/05??
 
Tori

Excel uses the settings from Short Date in Regional and Language Options as
the basis for the footer date format.

You can change it slightly in the Regional Options, but can't set it to
January 25, 2005

A macro will suffice if you want to go that route.

Sub DateInFooter()
ActiveSheet.PageSetup.RightFooter = Format(Now, "mmmm dd, yyyy")
End Sub


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

Problem formatting dates from CSV file 2
Sum amounts based on date field 6
Make all dates display 01 as the day 2
FORMULA TO ADD ROW 2
Change the format of my footer {date} option? 1
Change date format in Excel footer 2
Header/Footer Date Format 2
Counting distinct entries based on meeting month & year criteria 3

Back
Top