Formatting negative numbers in brackets in excel

M

Mark McDonough

No matter what I do, I cannot get Excel to show negative numbers in
brackets. Furthermore, I would like this to be the default format on opening
excel.

It rather surprises me that it is not the default or at least in the options
because most reprentations of negative numbers in accounting etc are
presented with negatives in brackets.
 
E

Earl Kiosterud

Mark,

Try Format - Cells - Custom, and one of these:

General;"["General"]"
0.00;"["0.00"]"
$#,##0.00;"["$#,##0.00"]"
 

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

Red cell for negative numbers in Excel 1
Excel not using regional settings 6
Simple question about negative numbers 5
default cell formatting for negative numbers 3
Displaying negatives with (brackets) 3
Excel Excel 2010-how to display negative % with brackets 0
Spreadsheets: negative numbers in brackets 2
Negative Number Formatting Excel 2007 1

Top