Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I format dates accessed by a formula
How do I format dates accessed by a formula that are included in a text
formula? I use excel 2002. cell a1 has ="as of "&A2 cell a2 currently displays December 30, 2004 Results show as of 38351 instead of as of December 30, 2004 . Any help would be appreciated. Thanks. Mont22 |
#2
|
|||
|
|||
="as of " & TEXT(A2, "mmmm dd, yyyy")
-- HTH RP (remove nothere from the email address if mailing direct) "Mont22" wrote in message ... How do I format dates accessed by a formula that are included in a text formula? I use excel 2002. cell a1 has ="as of "&A2 cell a2 currently displays December 30, 2004 Results show as of 38351 instead of as of December 30, 2004 . Any help would be appreciated. Thanks. Mont22 |
#3
|
|||
|
|||
Thanks Bob. The solution worked perfect.
"Bob Phillips" wrote: ="as of " & TEXT(A2, "mmmm dd, yyyy") -- HTH RP (remove nothere from the email address if mailing direct) "Mont22" wrote in message ... How do I format dates accessed by a formula that are included in a text formula? I use excel 2002. cell a1 has ="as of "&A2 cell a2 currently displays December 30, 2004 Results show as of 38351 instead of as of December 30, 2004 . Any help would be appreciated. Thanks. Mont22 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i create a formula or format the cells so the answer is a. | Excel Discussion (Misc queries) | |||
formula based on format | Excel Discussion (Misc queries) | |||
Date format collapses diagram | Excel Discussion (Misc queries) | |||
How do I format a character from a result of formula in excel? | Excel Discussion (Misc queries) | |||
Empty Cells, Spaces, Cond Format? | Excel Discussion (Misc queries) |