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

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

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 <(E-Mail Removed)>
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