Excel
 

How do I show negative numbers in brackets in Excel?

One way:

Format/Cells/Number/Custom General_);(General)


In article ,
"Ally" wrote:

How do I show negative numbers in brackets in Excel?

Using Format Cells, Number, Category = Custom...

try #,##0.00;(#,##0.00)

decimal places can be varied according to what you want



"Ally" wrote:

How do I show negative numbers in brackets in Excel?

Hi, Ally;
Format Cells Number Number
and
Format Cells Number Currency
both have that option.
-IanRoy

"Ally" wrote:

How do I show negative numbers in brackets in Excel?

Assuming brackets as being the "[]" characters, Format/Number/Custom, select
the #,##0_);(#,##0) format ant replace the (#,##0) with "["#,##0"]"
Gary

"Ally" wrote:

How do I show negative numbers in brackets in Excel?