Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Format Mismatch | Excel Discussion (Misc queries) | |||
date and time | New Users to Excel | |||
How do I calculate interest on actual date? | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
& reference answering as Date Serial # not actual text | Excel Worksheet Functions |