how do i get negative numbers to appear in brackets rather than minus sign
Do you think you get a better answer than in your original question How do you bracket negatives in calc, if you post the same thing a second time?
@erAck answered to use format code similiar to #,##0.00_);(#,##0.00)