text function question

[Travis]

I have the following formula in a cell:

="Inc. checks to be cut on "& TEXT(C6+3,"[$-409]dddd, mmmm dd, yyyy")

The cell output is:

Inc. checks to be cut on Monday, April 17, 2006

Is there a way to format the cell so that the text that is returned by
the TEXT function (e.g., "Monday, April 17, 2006") is bolded and/or the
font is a different color?

Any help would be much appreciated.

Regards,

Travis

 

[Peo Sjoblom]

No, it's not possible to format part of a formula


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Travis]

Thank you for the response.