Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is there a way to format the date in an excel footer eg just year
trying to automate a copywrite notice that contains just the year, is there a
way to limit/format how &[Date] shows in the footer? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is there a way to format the date in an excel footer eg just year
Record a macro when you add any old copyright date to a footer.
You'll get some code that boils down to something like: With ActiveSheet.PageSetup .CenterFooter = "Copyright: 12/25/2007" End With You can change it to: With worksheets("sheet9999").PageSetup .CenterFooter = "Copyright: " & format(date, "yyyy") End With Date is today's date -- like =today() in a cell. Mark wrote: trying to automate a copywrite notice that contains just the year, is there a way to limit/format how &[Date] shows in the footer? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i change the date format in a footer for all excel files? | Excel Discussion (Misc queries) | |||
How can you format a date in the header/footer of Excel sheet | Excel Discussion (Misc queries) | |||
Where can I change the footer &[Date] format in Excel 2003? | Setting up and Configuration of Excel | |||
How change the date format in the excel footer to dd mmm yy? | Excel Discussion (Misc queries) | |||
How do I change the default date format in an Excel Footer | Setting up and Configuration of Excel |