View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default Date format in Header

Filepage setupheader/footer or viewheader and footer, select custom,
select the date icon

--
Regards,

Peo Sjoblom

(No private emails please)


"Dr. Sachin Wagh" wrote in message
...
Thanx Venkataraman
Could you please elaborate on this 'highlight Header/ Footer'
My purpose is to have 'system date' automatically updated in the header
(with the said format)

Regards
--
Dr. Sachin Wagh
MBBS, DHA, DPH


"R.VENKATARAMAN" wrote:

highlight header/footer
format cells custom
and type in reference
dd mm yy
click ok
==============
"Dr. Sachin Wagh" wrote in
message
...
Hi!
Is is possible to have a customized format of Date (say, DD MM YY) for
Header/ Footer in Excel

Thanx
--
Dr. Sachin Wagh
MBBS, DHA, DPH