How to use
Click a cell in the amount column and choose Flip Signs under Accounting Tools. Check source-versus-output signs before using the result. Check the result before saving changes.
Assist Pro+ / Resources
Flip Signs
Reverses positive and negative amounts in the active accounting column.
Where to find it
Follow the ribbon path.
Assist Pro + → Resources → Finance Tools → Accounting Tools → Flip Signs
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 toolsPractical guidance
Use this tool in your workflow.
Best use case
Correcting the debit/credit sign presentation of an imported amount column.
Everyday Excel
Speeds recurring calculations in financial spreadsheets when you need to reverses positive and negative amounts in the active accounting column.
Accounting and audit
Speeds preparing or checking tax, depreciation, lease and ledger calculations by helping reverses positive and negative amounts in the active accounting column.