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
|