Date format in Header

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

with vba

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


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Dr. Sachin Wagh" <DrSachinWagh@discussions.microsoft.com> wrote in message
news:20E85EB0-19D6-43B0-BBD8-EA937C6F1626@microsoft.com...
> 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

highlight header/footer
format cells custom
and type in reference
dd mm yy
click ok
==============
"Dr. Sachin Wagh" <DrSachinWagh@discussions.microsoft.com> wrote in message
news:20E85EB0-19D6-43B0-BBD8-EA937C6F1626@microsoft.com...
> 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

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" <DrSachinWagh@discussions.microsoft.com> wrote in message
> news:20E85EB0-19D6-43B0-BBD8-EA937C6F1626@microsoft.com...
> > 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
>
>
>

File>page setup>header/footer or view>header and footer, select custom,
select the date icon

--
Regards,

Peo Sjoblom

(No private emails please)


"Dr. Sachin Wagh" <DrSachinWagh@discussions.microsoft.com> wrote in message
news:AA7CF867-1113-4501-8362-A6D1196FA68A@microsoft.com...
> 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" <DrSachinWagh@discussions.microsoft.com> wrote in
>> message
>> news:20E85EB0-19D6-43B0-BBD8-EA937C6F1626@microsoft.com...
>> > 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
>>
>>
>>

Probably the question is not understood properly. I need the System Date in
the header in DD MM YY format, which should be updated automatically
--
Dr. Sachin Wagh
MBBS, DHA, DPH


"Peo Sjoblom" wrote:

> File>page setup>header/footer or view>header and footer, select custom,
> select the date icon
>
> --
> Regards,
>
> Peo Sjoblom
>
> (No private emails please)
>
>
> "Dr. Sachin Wagh" <DrSachinWagh@discussions.microsoft.com> wrote in message
> news:AA7CF867-1113-4501-8362-A6D1196FA68A@microsoft.com...
> > 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" <DrSachinWagh@discussions.microsoft.com> wrote in
> >> message
> >> news:20E85EB0-19D6-43B0-BBD8-EA937C6F1626@microsoft.com...
> >> > 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
> >>
> >>
> >>
>
>

Not understood because it was not stated as such.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftHeader = Format(Date, "dd mm yy")
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code



--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Dr. Sachin Wagh" <DrSachinWagh@discussions.microsoft.com> wrote in message
news:FDA08041-1086-4F17-ACA6-0710D1DD1E24@microsoft.com...
> Probably the question is not understood properly. I need the System Date
in
> the header in DD MM YY format, which should be updated automatically
> --
> Dr. Sachin Wagh
> MBBS, DHA, DPH
>
>
> "Peo Sjoblom" wrote:
>
> > File>page setup>header/footer or view>header and footer, select custom,
> > select the date icon
> >
> > --
> > Regards,
> >
> > Peo Sjoblom
> >
> > (No private emails please)
> >
> >
> > "Dr. Sachin Wagh" <DrSachinWagh@discussions.microsoft.com> wrote in
message
> > news:AA7CF867-1113-4501-8362-A6D1196FA68A@microsoft.com...
> > > 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" <DrSachinWagh@discussions.microsoft.com> wrote in
> > >> message
> > >> news:20E85EB0-19D6-43B0-BBD8-EA937C6F1626@microsoft.com...
> > >> > 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
> > >>
> > >>
> > >>
> >
> >

Thanx a ton Bob!
I was responding to Venkataraman in my earlier reply

Your suggestion did the trick!

--
Dr. Sachin Wagh
MBBS, DHA, DPH


"Bob Phillips" wrote:

> Not understood because it was not stated as such.
>
> Private Sub Workbook_BeforePrint(Cancel As Boolean)
> ActiveSheet.PageSetup.LeftHeader = Format(Date, "dd mm yy")
> End Sub
>
> 'This is workbook event code.
> 'To input this code, right click on the Excel icon on the worksheet
> '(or next to the File menu if you maximise your workbooks),
> 'select View Code from the menu, and paste the code
>
>
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Dr. Sachin Wagh" <DrSachinWagh@discussions.microsoft.com> wrote in message
> news:FDA08041-1086-4F17-ACA6-0710D1DD1E24@microsoft.com...
> > Probably the question is not understood properly. I need the System Date
> in
> > the header in DD MM YY format, which should be updated automatically
> > --
> > Dr. Sachin Wagh
> > MBBS, DHA, DPH
> >
> >
> > "Peo Sjoblom" wrote:
> >
> > > File>page setup>header/footer or view>header and footer, select custom,
> > > select the date icon
> > >
> > > --
> > > Regards,
> > >
> > > Peo Sjoblom
> > >
> > > (No private emails please)
> > >
> > >
> > > "Dr. Sachin Wagh" <DrSachinWagh@discussions.microsoft.com> wrote in
> message
> > > news:AA7CF867-1113-4501-8362-A6D1196FA68A@microsoft.com...
> > > > 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" <DrSachinWagh@discussions.microsoft.com> wrote in
> > > >> message
> > > >> news:20E85EB0-19D6-43B0-BBD8-EA937C6F1626@microsoft.com...
> > > >> > 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
> > > >>
> > > >>
> > > >>
> > >
> > >
>
>
>