How do you bracket negative numbers in Calc
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).
Or is the problem that you want negative numbers to appear in brackets instead of with a minus sign?
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).
1 Like
- Select the cells to which you want to apply the format, and choose Format - Cells to start the Format Cells dialog.
- On the Numbers tab, in the Categories list box, select Number.
- In the bottom left, you will see the Format code field.
- If you want no decimals, enter
#;(#)as the new format. - If you want up to 2 decimals, enter
#.##;(#.##) - If you want to display zeros to 2 decimals, enter
0.00;(0.00) - If you want to display zeros to 2 decimals, and a thousands separator, enter
#,##0.00;(#,##0.00) - More formatting options are available here
- Click OK.