Date format in header
 

How can I make the date in the header apear as April 30, 2009 instead of
4/30/09?

Date format in header
 

Select the cell. Right click -- FormatCells--Date.
Select the required format.

If this post helps click Yes
---------------
Jacob Skaria


"Michael" wrote:

How can I make the date in the header apear as April 30, 2009 instead of
4/30/09?

Date format in header
 

The date is in the header, not in a cell. I can format a cell easily, but the
header is a whole other story.

"Jacob Skaria" wrote:

Select the cell. Right click -- FormatCells--Date.
Select the required format.

If this post helps click Yes
---------------
Jacob Skaria


"Michael" wrote:

How can I make the date in the header apear as April 30, 2009 instead of
4/30/09?

Date format in header
 

Excel uses the Windows short date format in headers/footers.

Very little formatting can be done with this.

Couple of options......................

Either enter the date as text or use VBA to change the formatting to what
you wish.

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


Gord Dibben MS Excel MVP

On Thu, 30 Apr 2009 10:43:08 -0700, Michael
wrote:

The date is in the header, not in a cell. I can format a cell easily, but the
header is a whole other story.

"Jacob Skaria" wrote:

Select the cell. Right click -- FormatCells--Date.
Select the required format.

If this post helps click Yes
---------------
Jacob Skaria


"Michael" wrote:

How can I make the date in the header apear as April 30, 2009 instead of
4/30/09?