Try custom formatting
#,##0;"("#,##0")"
to display a negative value as (20) or
#,##0;-"("#,##0")"
to display -(20)
Regards,
"Pandorad" wrote in message
...
How do I get negative numbers in brackets if <Format<Cells<Numbers drop
down
box does not show negative numbers in parenthesis. My spreadsheet shows
negative numbers with a '-' minus sign.
Thank you
Sheron
|