| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date format in Header
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date format in Header
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date format in Header
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date format in Header
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: 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date format in Header
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" wrote in message ... 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: 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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date format in Header
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" wrote in message ... 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: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing date format in a footer | Excel Discussion (Misc queries) | |||
| Customized Date Format | Excel Worksheet Functions | |||
| format date in excel | Excel Discussion (Misc queries) | |||
| Why Does Date Format Change on Chart | Excel Discussion (Misc queries) | |||
| USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
Linear Mode
