negative percentage in parenthetical format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)%.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

percentage in brackets 2
difference in numbers displayed as a +/- percentage 3
Get percentage of whole 2
Need formula to change cells from negative numbers to a zero. 2
Formatting negative percent 12
specific percentage formula 4
Formula w/negative no.s & Percentage 2
Negative percentage in data verification dropdown list? 2

Back
Top