- Selected the Total Liabilities and Equity line
- Right Click | Value Field Settings | Number Format
- Pick my custom format _(* (#,##0);_(* #,##0_);_(* "-"??_);_(@_) Notice that the parentheses are switched. Positive numbers have parentheses.
- Highlighed the Asset amounts
- I clicked the Comma icon to format the assets as Accounting, no currency symbol.
- Clicked the Decrease Decimal icon twice to remove the pennies.
The key is that we are manipulating how the items look, not how the calculations are done.