| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Brackets on negative percents.
Hello,
I am trying to get brackets to appear on a negative percentage from a formula. I know that I can retype it as '(2.1%) and it will show what brackets correctly, but I am wondering if there is something in the formula that can be added to display it correct. =-(C15-C16)/ABS(C15) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Brackets on negative percents.
You can change the cell format.
Custom section 0.00%;(0.00%) "Tracey C." wrote: Hello, I am trying to get brackets to appear on a negative percentage from a formula. I know that I can retype it as '(2.1%) and it will show what brackets correctly, but I am wondering if there is something in the formula that can be added to display it correct. =-(C15-C16)/ABS(C15) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Brackets on negative percents.
Thanks Sean. YOU ROCK!
"Sean Timmons" wrote: You can change the cell format. Custom section 0.00%;(0.00%) "Tracey C." wrote: Hello, I am trying to get brackets to appear on a negative percentage from a formula. I know that I can retype it as '(2.1%) and it will show what brackets correctly, but I am wondering if there is something in the formula that can be added to display it correct. =-(C15-C16)/ABS(C15) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Brackets on negative percents.
Why thank you! :-)
"Tracey C." wrote: Thanks Sean. YOU ROCK! "Sean Timmons" wrote: You can change the cell format. Custom section 0.00%;(0.00%) "Tracey C." wrote: Hello, I am trying to get brackets to appear on a negative percentage from a formula. I know that I can retype it as '(2.1%) and it will show what brackets correctly, but I am wondering if there is something in the formula that can be added to display it correct. =-(C15-C16)/ABS(C15) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Standard formatting not being applied to negative percents | Excel Discussion (Misc queries) | |||
| Negative Numbers in Brackets | Excel Discussion (Misc queries) | |||
| Negative figures in brackets | Excel Discussion (Misc queries) | |||
| Negative numbers in brackets | Excel Discussion (Misc queries) | |||
| How do I get brackets around negative numbers? | Excel Discussion (Misc queries) | |||
Linear Mode
