Excel 2000

  • Thread starter Thread starter David Hamer
  • Start date Start date
D

David Hamer

Is there a way to change the date format in footers and headers.?.these two
items do not seem to pick up the formatting specified for the individual
cells.

David H.
 
David

Excel in any version uses the Short Date format from Windows Regional settings
in headers/footers.

You can make some minor changes in Regional settings but not too much.

How about a macro to add the date in any format you choose?

Sub DateInFooter()
With ActiveSheet
.PageSetup.CenterFooter = Format(Date, "dddd, mmmm-dd-yyyy")
End With
End Sub


Gord Dibben MS Excel MVP
 
Hi David,

Change the Windows date format via the Control Panel

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Is there a way to change the date format in footers and headers.?.these two
| items do not seem to pick up the formatting specified for the individual
| cells.
|
| David H.
|
|
 
Back
Top