Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i change the date format in a footer?
How do i change the date format in a footer?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i change the date format in a footer?
Whatever format is in the Windows Regional and Language Settings governs what
the format is in the header or footer. These are very limited and Excel recognizes only a few for header formatting. To get a header date format of your choosing use a cell reference for the header. e.g. In A1 enter =TEXT(DATE(2006,12,10),"dddd, mmmm d"&", "&"yyyy") Then run this macro. Sub CellInHeader() With ActiveSheet ..PageSetup.CenterHeader = Range("A1").Value End With End Sub Gord Dibben MS Excel MVP -- William<"M" Using 2007 "Diane Goncalves" wrote: How do i change the date format in a footer? |
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 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 | |||
change date function format in footer | Excel Worksheet Functions | |||
Change the format of my footer {date} option? | Excel Discussion (Misc queries) |