Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I use long date format in a header or footer?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I use long date format in a header or footer?
You don't.
Excel defaults to short date. You can achieve a modicum of alteration in Windows Regional Settings but not like Thursday, November 16, 2005 To get that you would need a macro. Sub DateInFooter() With ActiveSheet .PageSetup.CenterFooter = Format(Date, "dddd, MMMM dd, yyyy") End With End Sub Alternative................. Assume you have date formatted to Thursday, November 16, 2005 in A1 Sub CellInFooter() With ActiveSheet .PageSetup.CenterFooter = .Range("A1").text End With End Sub Gord Dibben Excel MVP On Wed, 16 Nov 2005 16:12:03 -0800, "Long Date Format in Excel" <Long Date Format in wrote: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Format Squirrelly | Excel Discussion (Misc queries) | |||
DATE Format | Excel Worksheet Functions | |||
date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) | |||
Date & Time | New Users to Excel | |||
format the "date" button for a header | Excel Discussion (Misc queries) |