ExcelBanter - Special format for negative figures

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Special format for negative figures (https://www.excelbanter.com/excel-discussion-misc-queries/59376-special-format-negative-figures.html)

Dr. Sachin Wagh

Special format for negative figures

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

--
Dr. Sachin Wagh
MBBS, DHA, DPH

Niek Otten

Special format for negative figures

FormatCellsNumberCustom
In the Type box, enter

0%;(-0%)

--
Kind regards,

Niek Otten

"Dr. Sachin Wagh" wrote in message
...
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

--
Dr. Sachin Wagh
MBBS, DHA, DPH

Dr. Sachin Wagh

Special format for negative figures

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

"Niek Otten" wrote:

FormatCellsNumberCustom
In the Type box, enter

0%;(-0%)

--
Kind regards,

Niek Otten

"Dr. Sachin Wagh" wrote in message
...
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

--
Dr. Sachin Wagh
MBBS, DHA, DPH

All times are GMT +1. The time now is 11:54 PM.