Thread: Is there a way to change the date format of footers?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Is there a way to change the date format of footers?
You can effect some small changes in Regional and Language Settings in Control
Panel.

Change the short date format.

For major changes you would need VBA code.

Sub date_footer()
ActiveSheet.PageSetup.RightFooter = Format(Now, "yyyy-mmm-dd hh:mm:ss")
End Sub


Gord Dibben MS Excel MVP

On Mon, 7 Jan 2008 12:10:02 -0800, xanderkim
wrote:


Reply With QuoteReply With Quote