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

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
|
|