with vba

ActiveSheet.PageSetup.LeftHeader = Format(Date, "dd mm yy")


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"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