How do you put negative/minus numbers in brackets

S

SteveW

You can set custom to #;"("#")";#
But there is an easier way - can't find it though

Steve
 
J

Jim Rech

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
Displaying negatives with (brackets) 3
show negative figures in brackets 3
Negative numbers in brackets 4
Excel not using regional settings 6

Top