Equations and Text in same Cell

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?
 
G

Gord Dibben

Something like this?

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I can't copy and paste equations 0
Format a field in an equation 4
Equations appear as text 1
Setting the number of decimal places for a text box. 3
why is answer rounded up? 1
spliting whole number and decimal 5
Excel Excel 2007 won't stop rounding down my formula results! 5
=RAND produces decimals not whole numbers 9

Top