| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I alter the date format in the footer in Excel?
Whenever I set a date in the footer of Excel 2007, I get the SAME type of
format, i.e. "mm/dd/yyyy". The machine shows something like, say, "10/9/2007". I want to change this to show soething like: "Tuesday, October 9, 2007" Or evef, : "Tue, Oct 09, 2007". How can I get this done ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I alter the date format in the footer in Excel?
The date Excel places in headers and footers depends upon the Regional Settings
Date and you are limited to only a few variations. I prefer a macro. Sub DateInFooter() ActiveSheet.PageSetup.RightFooter = Format(Date, "dddd, mmmm dd, yyyy") End Sub Gord Dibben MS Excel MVP On Tue, 9 Oct 2007 07:49:03 -0700, haryalco wrote: Whenever I set a date in the footer of Excel 2007, I get the SAME type of format, i.e. "mm/dd/yyyy". The machine shows something like, say, "10/9/2007". I want to change this to show soething like: "Tuesday, October 9, 2007" Or evef, : "Tue, Oct 09, 2007". How can I get this done ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is there a way to format the date in an excel footer eg just year | Excel Worksheet Functions | |||
| How do i change the date format in a footer for all excel files? | Excel Discussion (Misc queries) | |||
| Why do reports from MYOB to Excel alter the date format | Excel Discussion (Misc queries) | |||
| 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 | |||
Linear Mode
