Special format for negative figures

[Dr. Sachin Wagh]

How do I get parenthesis i.e. () for negative %
ex: (-5%)
as we get for numbers

though managed to get it red coloured thru Conditional Formatting

Pls help

 

[Niek Otten]

Format>Cells>Number>Custom
In the Type box, enter

0%;(-0%)

 

[Dr. Sachin Wagh]

Thanx Niek
--
Dr. Sachin Wagh
MBBS, DHA, DPH

Format>Cells>Number>Custom
In the Type box, enter

0%;(-0%)