Format a portion of cell only

  • Thread starter Thread starter Joe Gieder
  • Start date Start date
J

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
 
Is there a way to format this so it
would show $12,000.00 instead of $12000.00 I want to add
the comma?
Click to expand...

Try

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

HTH,
Andy
 
One way:

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

TEXT() will round automatically.
 
Back
Top