Equations and Text in same Cell

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

I am using Excel to write a program. I would like to incorporate text within
the same cell as the result of an equation but the I cannot control the
number of decimal places that the output displays. I've tried using the
Number tab in the Format Cell feature but nothing changes.

Is there a way to control the number of decimal places when you are
combining text with the results of an equation?
 
Something like this?

="You now owe us " & TEXT(A2,"$#,##0.00")


Gord Dibben MS Excel MVP
 
Back
Top