How to use
Place the active cell in the amount column, then choose Clean Amounts. Review amounts originally containing currency symbols, spaces, brackets or CR indicators. Check the result before saving changes.
Assist Pro+ / Resources
Clean Amounts
Normalises imported accounting amounts and debit/credit conventions.
Where to find it
Follow the ribbon path.
Assist Pro + → Resources → Finance Tools → Accounting Tools → Clean Amounts
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
Removing currency characters and sign conventions from imported amounts.
Everyday Excel
Speeds recurring calculations in financial spreadsheets when you need to normalises imported accounting amounts and debit/credit conventions.
Accounting and audit
Speeds preparing or checking tax, depreciation, lease and ledger calculations by helping normalises imported accounting amounts and debit/credit conventions.