Formatting negative numbers in brackets in excel

  • Thread starter Thread starter Mark McDonough
  • Start date Start date
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.
 
Mark,

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

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