change date function format in footer

T

Tori

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

Gord Dibben

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
 

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

Dcount -Date Criteria - Won´t find it - 0
Problem formatting dates from CSV file 2
Section and Page numbering 0
Make all dates display 01 as the day 2
Sum amounts based on date field 6
Date Format 10
FORMULA TO ADD ROW 2
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0

Top