Format and Concatenation

[C Brandt]

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

 

[Peo Sjoblom]

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

 

[MyVeryOwnSelf]

... 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.

If the number is in A1, one way would be something like this:
="The value is "&TEXT(A1,"$#,##0.00")&" today."

 

[C Brandt]

Thanks All.

Exactly what I needed!