U
Uttster
I only get [Date] to appear on my Excel doc not March 24, 2005. TIA
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
How to get actual date instead of [Date] to appear in Excel Heade.
G
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
=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
U
uttster
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
"print preview" , "[Date]" shows up not "March 23, 2005".
Thanks
Gord Dibben said: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
G
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
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
Gord Dibben said: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
U
uttster
Thanks for your responses.
I am clicking the date button and the &[date] appears
Quirky huh?
Thanks again
I am clicking the date button and the &[date] appears
Quirky huh?
Thanks again
Gord Dibben said: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
Gord Dibben said: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