Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Try this:
="11 ("&TEXT(11/C2,"0.00%")&")" Does that help? *********** Regards, Ron XL2002, WinXP "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 |
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 |