Ask Your Question

How do you bracket negatives in calc

asked 2019-04-28 16:51:36 +0200

Jimwest gravatar image

How do you bracket negative numbers in Calc

edit retag flag offensive close merge delete


What is the problem? Please show an example, since I do not see any difference in bracketing positive or negative numbers (general math rules on precedence of operators apply).

Opaque gravatar imageOpaque ( 2019-04-28 17:09:07 +0200 )edit

Or is the problem that you want negative numbers to appear in brackets instead of with a minus sign?

ve3oat gravatar imageve3oat ( 2019-04-28 20:31:10 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-04-29 15:42:53 +0200

erAck gravatar image

Format code #,##0.00_);(#,##0.00) as taken from the English (USA) list of Number format codes (adjust to your locale's group and decimal separator).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-04-28 16:51:36 +0200

Seen: 84 times

Last updated: Apr 29