![]() |
Decrease Decimal in a combined text/formula cell
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 04:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com