A
Ally
How do I show negative numbers in brackets in Excel?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
One way:
Format/Cells/Number/Custom General_);(General)
Format/Cells/Number/Custom General_);(General)
M
Mark Hunt
Using Format Cells, Number, Category = Custom...
try #,##0.00;(#,##0.00)
decimal places can be varied according to what you want
try #,##0.00;(#,##0.00)
decimal places can be varied according to what you want
I
IanRoy
Hi, Ally;
Format> Cells> Number> Number
and
Format> Cells> Number> Currency
both have that option.
-IanRoy
Format> Cells> Number> Number
and
Format> Cells> Number> Currency
both have that option.
-IanRoy
G
Gary Rowe
Assuming brackets as being the "[]" characters, Format/Number/Custom, select
the #,##0_);(#,##0) format ant replace the (#,##0) with "["#,##0"]"
Gary
the #,##0_);(#,##0) format ant replace the (#,##0) with "["#,##0"]"
Gary