View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sriram Sriram is offline
external usenet poster
 
Posts: 50
Default 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