Stand in a financial column. Applies accounting formatting with brackets for negatives and dashes for zero.
Assist Pro + → Resources → Finance Tools → Accounting Tools → Accounting Format
Part of Assist Pro+. Eligible tools can also be selected through Assist Pro’s 30-tool Vault allowance. Check the Vault for availability.
Open the tool and follow its prompts. Use a copy of your workbook when trying an action for the first time, then check the result.
Browse all toolsChoose the accounting schedule or source-column range you need to calculate or inspect. On Assist Pro + › Resources › Finance Tools › Accounting Tools, choose Accounting Format to stand in a financial column. Applies accounting formatting with brackets for negatives and dashes for zero. Compare the calculation or reference to the actual transaction, agreement or applicable guidance.
Preparing transaction amounts or debit/credit columns for financial review and reconciliation.
Speeds recurring calculations in financial spreadsheets when you need to apply accounting formatting with brackets for negatives and dashes for zero.
Speeds preparing or checking tax, depreciation, lease and ledger calculations by helping apply accounting formatting with brackets for negatives and dashes for zero.