Prev: Access denied when running Excel from DOS prompt with runas co
Next: Using Excel as a markbook for attendance and assessment
From: Eric on 27 Apr 2010 16:28
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?
From: FSt1 on 27 Apr 2010 16:43
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?
From: Gord Dibben on 27 Apr 2010 17:07
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 <Eric(a)discussions.microsoft.com>
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?

 | 
Pages: 1
Prev: Access denied when running Excel from DOS prompt with runas co
Next: Using Excel as a markbook for attendance and assessment