Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can you format a date in the header/footer of Excel sheet
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can you format a date in the header/footer of Excel sheet
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can you format a date in the header/footer of Excel sheet
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can you format a date in the header/footer of Excel sheet
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert a month to a quarter ...... | New Users to Excel | |||
Excel 2007 Date Format Problem | Excel Discussion (Misc queries) | |||
Mileage Claim Formula | New Users to Excel | |||
Excel default date format | Excel Discussion (Misc queries) | |||
EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) |