Format Date in Header

[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 ?

 

[Claus Busch]

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.

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


Regards
Claus Busch

 

[Stuart]

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

Claus
Thanks very much. Just what I wanted
Stuart