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

="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

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

Thanks All.

Exactly what I needed!




"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