MrExcel Publishing
Your One Stop for Excel Tips & Solutions

date and text together


Posted by Ed on September 27, 2001 10:12 AM


I have the following in a cell

="text text text text "&F10" text text text text"

The reference is calling a field with a date. I want the date to show in the text in a date format (any date format at this point). I have tried formatting the entire cell as date, but it is not working.

Please help.

Thank you.

ed


Posted by Ed on September 27, 2001 10:14 AM

I left off an ampersand should be....

="text text text text "&F10&" text text text text"

Incorporating text and called cells is not my problem. Although from my original message it might look that way.

Thank you.

ed

Posted by Barrie Davidson on September 27, 2001 10:18 AM

Try using
="text text text text "&TEXT(F10,"mmm d, yyyy")&" text text text text"

You can change the formatting of the date by changing the text string "mmm d, yyyy" to whatever format you want.

Regards,
BarrieBarrie Davidson