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

[Guest]

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

 

[Gord Dibben]

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

 

[Guest]

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

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

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

 

[Gord Dibben]

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

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

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

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

 

[Guest]

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

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

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

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"

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