Format Date in Header

  • Thread starter Thread starter Stuart
  • Start date Start date
S

Stuart

I've forgotten how to do it.
When I print out from Excel 2010 i want the current date in the header - left. In the screen in Page Layout if I press the button and get @Date it gives me 11/10/12 for today - 11 October 2012. I want "10 Oct 12".
I've tried "Format Date ddmmyy" and similar strings but no success.
Can anyone help ?
 
Hi Stuart,

Am Thu, 11 Oct 2012 07:01:57 -0700 (PDT) schrieb Stuart:
When I print out from Excel 2010 i want the current date in the header - left. In the screen in Page Layout if I press the button and get @Date it gives me 11/10/12 for today - 11 October 2012. I want "10 Oct 12".
I've tried "Format Date ddmmyy" and similar strings but no success.
Click to expand...

do it with VBA:
Sub myLeftHeader()
With ActiveSheet.PageSetup
.LeftHeader = Format(Date, "dd MMM yy")
End With
End Sub


Regards
Claus Busch
 
Hi Stuart,



Am Thu, 11 Oct 2012 07:01:57 -0700 (PDT) schrieb Stuart:







do it with VBA:

Sub myLeftHeader()

With ActiveSheet.PageSetup

.LeftHeader = Format(Date, "dd MMM yy")

End With

End Sub





Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2
Click to expand...

Claus
Thanks very much. Just what I wanted
Stuart
 
Back
Top