Turn positive values negative and negative values positive.
Assist Pro + → Find / Quick Access → 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 toolsOpen the Excel workbook in which you want to use the command. On Assist Pro + › Find / Quick Access, choose Flip Signs to turn positive values negative and negative values positive. Confirm the target workbook or selected cells before rerunning a saved action.
Correcting the debit/credit sign presentation of an imported amount column.
Reduces repeated clicks and manual edits in everyday spreadsheets when you need to turn positive values negative and negative values positive.
Speeds preparing working-paper schedules and client exports when you need to turn positive values negative and negative values positive.