Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Equations and Text in same Cell
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Equations and Text in same Cell
yes. you could incorperate the round() funciton.
post your formula regards FSt1 "Eric" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Equations and Text in same Cell
Something like this?
="You now owe us " & TEXT(A2,"$#,##0.00") Gord Dibben MS Excel MVP On Tue, 27 Apr 2010 13:28:01 -0700, Eric wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping a cell or value constant in further equations | Excel Discussion (Misc queries) | |||
Equations appear as text | Excel Discussion (Misc queries) | |||
Equations | Excel Discussion (Misc queries) | |||
How can I put chart trendline equations into a MS Excel cell? | Excel Discussion (Misc queries) | |||
Added text to equations | Excel Discussion (Misc queries) |