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 |
="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 |
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 |
All times are GMT +1. The time now is 10:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com