Tools Vault selection / Pro+ collection
Use Tool Finder if you do not know the ribbon group. Confirm the final location in your installed version.
Tool guide
Flip signs in a selected range
A consistent set of imported values has the opposite sign convention from the one you need.
What it solves
Use this when…
A consistent set of imported values has the opposite sign convention from the one you need.
Expected result: Selected signs reverse; the original file remains available for comparison.
How to use
Follow these steps
Try the action on a copy of your workbook first.
1
Save a copy
Preserve the export and note the current total.
2
Select only the affected values
Exclude headings, subtotals and unaffected rows.
3
Run Flip Signs and compare
Check a few positive and negative values and reconcile the updated total.
Before you finish
Check the output
Confirm the result against the source and keep your own judgement in the loop.
Unexpected input format
Check headings, selected ranges and text/number formats before running. Work on a copy for consequential changes.
Ready to explore?
Make Excel work better for you.
Start with the current 10-day trial, or speak to us about what your team needs.