I think this will work for you:
=TEXT(string,"format")
You could add -- in front of TEXT to ensure it is viewed as numeric by excel
if you need it too. For example, say you wanted to state something like
The cost of the product is $17.99. Thank you for your order.

You could do the following:
=CONCATENATE("The cost of your product ",TEXT(cost,"$#,##0.00"),". Thank you
for your order.")

If this isn't what you were looking for, reply back and give more details.
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"John G" wrote:

I have a concatenate string with various numerical entries. I want to format
the numercial returns with varying formats. What function do I need to
incorporate into my string surrounding each numeric & pickup?