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 |
All times are GMT +1. The time now is 12:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com