How to get actual date instead of [Date] to appear in Excel Heade.
 

I only get [Date] to appear on my Excel doc not March 24, 2005. TIA

How are you entering the date?

=TODAY() and format as mmmm dd, yyyy

OR Hit CTRL + ;(semi-colon) and format as above.

OR enter the date directly like 3/24/2005 or 25/3/2005 depending upon your
Regional Settings.


Gord Dibben Excel MVP

On Thu, 24 Mar 2005 14:13:04 -0800, "Uttster"
wrote:

I only get [Date] to appear on my Excel doc not March 24, 2005. TIA

I am going into the custom header and inserting the date field. When I do
"print preview" , "[Date]" shows up not "March 23, 2005".

Thanks

"Gord Dibben" wrote:

How are you entering the date?

=TODAY() and format as mmmm dd, yyyy

OR Hit CTRL + ;(semi-colon) and format as above.

OR enter the date directly like 3/24/2005 or 25/3/2005 depending upon your
Regional Settings.


Gord Dibben Excel MVP

On Thu, 24 Mar 2005 14:13:04 -0800, "Uttster"
wrote:

I only get [Date] to appear on my Excel doc not March 24, 2005. TIA

Are you clicking on the Date button or entering manually?

If manually, enter as &[Date]

Note the ampersand(&)

If clicking on the button, you should see &[Date] in the field.


Gord

On Thu, 24 Mar 2005 15:27:02 -0800, "uttster"
wrote:

I am going into the custom header and inserting the date field. When I do
"print preview" , "[Date]" shows up not "March 23, 2005".

Thanks

"Gord Dibben" wrote:

How are you entering the date?

=TODAY() and format as mmmm dd, yyyy

OR Hit CTRL + ;(semi-colon) and format as above.

OR enter the date directly like 3/24/2005 or 25/3/2005 depending upon your
Regional Settings.


Gord Dibben Excel MVP

On Thu, 24 Mar 2005 14:13:04 -0800, "Uttster"
wrote:

I only get [Date] to appear on my Excel doc not March 24, 2005. TIA

Thanks for your responses.
I am clicking the date button and the &[date] appears
Quirky huh?
Thanks again

"Gord Dibben" wrote:

Are you clicking on the Date button or entering manually?

If manually, enter as &[Date]

Note the ampersand(&)

If clicking on the button, you should see &[Date] in the field.


Gord

On Thu, 24 Mar 2005 15:27:02 -0800, "uttster"
wrote:

I am going into the custom header and inserting the date field. When I do
"print preview" , "[Date]" shows up not "March 23, 2005".

Thanks

"Gord Dibben" wrote:

How are you entering the date?

=TODAY() and format as mmmm dd, yyyy

OR Hit CTRL + ;(semi-colon) and format as above.

OR enter the date directly like 3/24/2005 or 25/3/2005 depending upon your
Regional Settings.


Gord Dibben Excel MVP

On Thu, 24 Mar 2005 14:13:04 -0800, "Uttster"
wrote:

I only get [Date] to appear on my Excel doc not March 24, 2005. TIA