Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I change the default date format in an Excel Footer
I need to change the date format in an Excel footer from e.g. 05.02.2005 to
05-Feb-2005. How can I do this? |
#2
|
|||
|
|||
You can either type in exactly what you want...
or you can use a macro that runs each time you print. Option Explicit Private Sub Workbook_BeforePrint(Cancel As Boolean) With Worksheets("sheet1").PageSetup .LeftFooter = Format(Date, "dd-mmm-yyyy") End With End Sub This goes into the ThisWorkbook module. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Burki wrote: I need to change the date format in an Excel footer from e.g. 05.02.2005 to 05-Feb-2005. How can I do this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
how do I change the text case of imported data in excel? | Excel Discussion (Misc queries) | |||
Change the format of my footer {date} option? | Excel Discussion (Misc queries) | |||
Excel Date Format - Stop? | Excel Worksheet Functions | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel |