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.

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.