formating negative percentages

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

Guest

In Excel I wish to format a negative percentage so that is displays as
(141%). I am able to put the ( )'s in but can't get rid of the - sign. Any
suggestions
 
Format of 0%;(0%)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
In Excel I wish to format a negative percentage so that is displays as
(141%). I am able to put the ( )'s in but can't get rid of the - sign. Any
suggestions
Click to expand...


Format/Cells/Number/Custom Type: 0%;(0%)


--ron
 
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

Negative percentage in data verification dropdown list? 2
Formating cells to display negative percentages in red fon... 3
Negative Percentage 2
Custom cell format for percentage 3
How do I show negative percentage in a fomula? 1
How do I calculate variance percetage if figures are negative 5
Conditional Format Negative to Postiive Numbers w/3 Symbol Icon Se 2
Dividing - Negative Number by Zero 5

Back
Top