Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell References | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
insert date | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
How many decimal places can a cell display? | Excel Worksheet Functions |