| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
negative percentage in parenthetical format
I'm creating a comparative balance sheet and I need to know how to format
-0.5412 into (54.12)% the catch is the numbers are based on a formula and cannot be altered. I've been at it for a while and I just can't figure it out. |
|
#2
|
|||
|
|||
|
negative percentage in parenthetical format
Why can't you use a custom format with
0.00%;(0.00)% as the type? This will show 0.5412 as 54.12% and -0.5412 as (54.12)%. "Dana" wrote: I'm creating a comparative balance sheet and I need to know how to format -0.5412 into (54.12)% the catch is the numbers are based on a formula and cannot be altered. I've been at it for a while and I just can't figure it out. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Negative Values Only | Excel Discussion (Misc queries) | |||
| How to format a date to a different format | Excel Discussion (Misc queries) | |||
| Format cell for negative | Excel Discussion (Misc queries) | |||
| protecting format | Excel Discussion (Misc queries) | |||
| Percentage format | Excel Worksheet Functions | |||
Linear Mode
