Formatting date in footer

  • Thread starter Thread starter jayray
  • Start date Start date
J

jayray

In my footer, I've put &[Date] and it appears correctly as 4/29/07 for
today. How can I make it appear as "April 29, 2007"? I can't figure
out the place to change this format.

Thanks for any information.
 
jayray

Excel uses the Windows short date formatting for the footer date.

You can make some limited changes in Windows Regional Settings to your short
date format.

Not sure you can get April 29, 2007 format but give it a try.

Alternate solution...........use a macro.

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


Gord Dibben MS 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

Footer date format 2
change of date format in footer 4
Set Up Calendar To Account For Leap Years 2
Join text and 2 dates in A2 column in worksheet 5
last date saved in excel 7
Getting the date from my left footer 3
Chart Print Footer :: Excel 2007 3
change date format on cover page 1

Back
Top