="some text yada yada "&TEXT(A1,"$#,##0.00")


--
Regards,

Peo Sjoblom



"C Brandt" wrote in message
...
I am preparing data in an Excel file to be used in the body of an email. I
am using CONCATENATE to assemble a line of text. One of the components of
the string is a number which is formated in the spread sheet as $40,015.00
and I would like that format to appear in the result of the concatenation.
It currently appears as 40015.
Does anyone know how I can get the number to appear as $40,015 after the
concatenation.

Thanks for any assistance you can render on this issue,
Craig