Change Format of Date in Header

[Sriram]

Hi All,
While inserting &[Date] in the Header of an Excel Worksheet, the date on my
Print appears as 4/21/2008 which is not the way I want.
I want it displayed as 21-Apr-2008.
And I do not find any formatting button as in the case of a normal excel
Worksheet where we can choose from the date Templates available.

Any help would be greatly appreciated.

Sriram

 

[ryguy7272]

I think you can only do this with a macro:

Public Sub sampledate()
ActiveSheet.PageSetup.LeftFooter = Format(Now, "d mmm yy")
ActiveSheet.PageSetup.LeftHeader = Format(Now, "d mmm yy")
End Sub


Look here is you are unfamiliar with using macros:
http://www.anthony-vba.kefra.com/vba/vbabasic1.htm#Creating_Your_First_Macro

Regards,
Ryan--

 

[Gord Dibben]

You have a very limited control over this by your short date settings in Windows
Regional and Laguage settings.

The closest I can achieve is 21-04-08 from those settings

Otherwise see Ryan's macro solution.


Gord Dibben MS Excel MVP