Change Format of Date in Header
 

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

Change Format of Date in Header
 

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...ur_First_Macro

Regards,
Ryan--

--
RyGuy


"Sriram" wrote:

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

Change Format of Date in Header
 

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

On Mon, 21 Apr 2008 05:48:01 -0700, Sriram
wrote:

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