Format a portion of cell only

[Joe Gieder]

I use the statement below in one of my cells and what I
was wondering is that this part "$"&ROUND(B11,2) pulls
out a dollar value. Is there a way to format this so it
would show $12,000.00 instead of $12000.00 I want to add
the comma?

"Minimum Buy Excess Purchased with S/S One (Included
in "&"$"&ROUND(B11,2)&" Total Raw Cost above)"

TIA
Joe

 

[Andy Brown]

Is there a way to format this so it

would show $12,000.00 instead of $12000.00 I want to add
the comma?

Try

="Minimum Buy Excess Purchased with S/S One (Included in
"&TEXT(ROUND(B11,2),"$#,##0.00")&" Total Raw Cost above)"

HTH,
Andy

 

[JE McGimpsey]

One way:

= "Minimum Buy Excess Purchased with S/S One (Included
in " & TEXT(B11,"$#,##0.00") & " Total Raw Cost above)"

TEXT() will round automatically.

 

[Joe Gieder]

Thank You. It's just what I was looking for.