Formatting &[Date] in header Excel 2000

  • Thread starter Thread starter Harley Cooper
  • Start date Start date
H

Harley Cooper

How can I change the default date format (8/18/2004) in the header/footer to
a different date format (18-Sep-04)?

Thanks
 
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

(e-mail address removed)

| How can I change the default date format (8/18/2004) in the header/footer
to
| a different date format (18-Sep-04)?
|
| Thanks
|
|
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting &Date in Header/Footer 1
Date match problem 2
Formatting Date in Header or Footer 1
Access Count dates within a Month 4
Formatted Date in header applied with a macro 6
Date format. 1
Subtracting AD and/or BC dates 21
Problem formatting dates from CSV file 2

Back
Top