Change the format of my footer {date} option?

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

Guest

I would like to show the date in my footer as January 25, 2005 instead of the
default 01/25/05
 
Private Sub Workbook_BeforePrint(Cancel As Boolean)
With ActiveSheet
.PageSetup.LeftFooter = Format(Date, "mmmm dd, yyyy")
End With
End Sub


put this in the ThisWorkbook code module.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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

change date function format in footer 1
How do I format the date in a footer to display the month in lett. 1
If statement with dates 0
Footer date format 2
DATE SORTING excel 2
sorting dates in a worksheet 3
complex color fill conditions- if statements or complex formula? 1
COUNT BETWEEN A SPECIFIC DATE RANGE 4

Back
Top