ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Decrease Decimal in a combined text/formula cell (https://www.excelbanter.com/excel-worksheet-functions/121077-decrease-decimal-combined-text-formula-cell.html)

Zakhary

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