If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
change date function format in footer
I would like to change the automatic date function in my footer to ie.
January 25, 2005 instead of 01/25/05?? |
#2
|
|||
|
|||
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 On Tue, 25 Jan 2005 10:01:03 -0800, "Tori" wrote: I would like to change the automatic date function in my footer to ie. January 25, 2005 instead of 01/25/05?? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Change date format in several worksheets | Steven Shouse | New Users | 2 | October 31st, 2004 11:58 PM |
QDE (Quick Date Entry) | Norman Harker | General Discussion | 3 | September 3rd, 2004 08:00 AM |
Repost-Still Suffering with Subreports | IreneJ | Setting Up & Running Reports | 9 | August 31st, 2004 04:55 AM |
Unable to change date format | kd | Worksheet Functions | 2 | June 16th, 2004 05:57 PM |