formating negative percentages

J

Jo

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
 
B

Bob Phillips

Format of 0%;(0%)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
R

Ron Rosenfeld

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
 
Top