How can you format a date in the header/footer of Excel sheet
Thanks for the feedback Sam
If you decided to go with this and need a changing date just alter the A1
formula to =TEXT(TODAY(),"dddd, mmmm d"&", "&"yyyy")
Gord
On Sun, 10 Dec 2006 19:12:05 -0800, "SAM SEBAIHI"
wrote:
Thank you so much Gord. I do appreciate your help through out this
newsgroup.
--------------------------------------------------------------------------------
Sam Sebaihi Faculty Western
"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Sam
Added info.
Excel only recognizes the Windows Short Date setting for headers and
footers.
Also..............
You can edit the macro for RightHeader or LeftFooter or wherever you want.
Gord
On Sun, 10 Dec 2006 14:17:10 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:
Sam
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
On Sun, 10 Dec 2006 13:43:17 -0800, "SAM SEBAIHI"
wrote:
When viewing a header/footer, I would like to insert a date in spcial
format, how can I do this?
--------------------------------------------------------------------------------
Sam Sebaihi
Faculty
Western International University
Associate Programs
(alternate email)
Phone #: (405)315-8223 Time zone: Pacific Time
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP
|