Decrease Decimal in a combined text/formula cell
Could you wrap your formula with the ROUND function? See if this works
perhaps?:
=ROUND("11 ("&11/C2%&"%)",2)
If that does not work you might have to work the round function into the
middle of your formula wrapping it around the division calculation.
"Zakhary" wrote:
Subject line says it all. I have a few cells where I have combined text with
a formula. The formula produces a decimal and I want to decrease the number
of decimal spaces therein. Using the basic buttons doesn't seem to work, nor
does going through the "format cell" system work. How do I decreae the
number of decimal places in a formula when the formula is combined with text.
Below is a formula to use as an example...
="11 ("&11/C2%&"%)"
displays... 11 (52.3809523809524%)
I want it to display... 11 (52.38%)
Thanks,
Zakhary
|