 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008Excel 2000
Is there a way to change the date format in footers and headers.?.these two items do not seem to pick up the formatting specified for the individual cells. David H. David Excel in any version uses the Short Date format from Windows Regional settings in headers/footers. You can make some minor changes in Regional settings but not too much. How about a macro to add the date in any format you choose? Sub DateInFooter() With ActiveSheet .PageSetup.CenterFooter = Format(Date, "dddd, mmmm-dd-yyyy") End With End Sub Gord Dibben MS Excel MVP >Is there a way to change the date format in footers and headers.?.these two >items do not seem to pick up the formatting specified for the individual >cells. > >David H. Hi David, Change the Windows date format via the Control Panel  SignatureKind regards, Niek Otten Microsoft MVP - Excel | Is there a way to change the date format in footers and headers.?.these two | items do not seem to pick up the formatting specified for the individual | cells. | | David H. Niek, Gord... Thank you...works fine. I learn something new every day! David H. > Hi David, > [quoted text clipped - 6 lines] > | > | David H. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.