Text and a Link to a Date in Another Cell

[TKrepitch]

How can I write "...as of February 25, 2005" in a cell when I put the
words in one cell and link to the date in another cell.

Right now, I am using the following formula:

="...as of "&B4

where B4 has the date.

The result is ...as of 38405. I want to change the 38405 format to the
February 22, 2005 format, but can't remember how.

Thanks!

 

[JE McGimpsey]

One way:

="...as of " & TEXT(B4,"mmmm dd, yyyy")

 

[Peo Sjoblom]

With excel 2002 onward you can do it using data>text co columns, click next
, next and advanced
treat trailing minus as negative, then click finish. Otherwise

http://www.mcgimpsey.com/excel/postfixnegatives.html

 

[TKrepitch]

That's it! Thank you very much!

 

[Peo Sjoblom]

Sorry, wrong thread


--

Regards,

Peo Sjoblom

With excel 2002 onward you can do it using data>text co columns, click next
, next and advanced
treat trailing minus as negative, then click finish. Otherwise

http://www.mcgimpsey.com/excel/postfixnegatives.html


--

Regards,

Peo Sjoblom