How do you put negative/minus numbers in brackets

  • Thread starter Thread starter Guest
  • Start date Start date
You can set custom to #;"("#")";#
But there is an easier way - can't find it though

Steve
 
In the Format Cells dialog, with "Number" selected the third "negative
numbers" option shows parens (or brackets as they say in England, etc.). If
you do not see a bracketed format there you have to change your negative
number format for CURRENCY (not Numbers) under Windows Control Panel,
Regional Settings to use parens.

--
Jim
| Hello,
|
| How do you get minus/negative numbers to appear in brackets?
|
| Thanks.
 

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 figures in brackets 13
Option to put brackets around negative numbers not available in 20 3
Negative Numbers in Brackets 2
How can I show negative numbers in brackets in spreadsheet 4
show negative figures in brackets 3
Displaying negatives with (brackets) 3
Negative numbers in brackets 4
I want to get brackets round my figures not minus signs 3

Back
Top