| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting &[Date] in header Excel 2000
How can I change the default date format (8/18/2004) in the header/footer to
a different date format (18-Sep-04)? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formatting &[Date] in header Excel 2000
Hi Harley
To use code.... ActiveSheet.PageSetup.LeftFooter = Format(Date, "dd mmm yy") Place the code in the "BeforePrint" event of the "ThisWorkbook" module of the relevant workbook if you want it to execute each time a sheet is printed, -- XL2002 Regards William "Harley Cooper" wrote in message ... | How can I change the default date format (8/18/2004) in the header/footer to | a different date format (18-Sep-04)? | | Thanks | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does Excel 2000 crash when formatting a cell to Date? | Excel Discussion (Misc queries) | |||
| How can I include bmp file in excel 2000 header? | Excel Worksheet Functions | |||
| Formatting Date in Header & Footer | Excel Discussion (Misc queries) | |||
| In Excel 2000, can I print the header on the first page only? | Excel Worksheet Functions | |||
| Date Button in Header (Excel 2000) | Excel Discussion (Misc queries) | |||
Hybrid Mode
