Tip of the Day | Wednesday 29 July 2026

Discover new tools to get things done.

Change Number Signs: Reverse or Make All Positive or Negative...

This tool allows you to modify number signs in your selected cells quickly.
You can:

  • Make all numbers positive (e.g., -10 → 10, 15 → 15).
  • Make all numbers negative (e.g., -10 → -10, 15 → -15).
  • Reverse positive and negative numbers (e.g., -10 → 10, 15 → -15).

This feature is handy for correcting financial data, balance sheets, debit/credit values, or imported datasets where number signs need adjustments.

Note: Cells with formulas are skipped to preserve calculations.

Starting this tool

Specify a Keyboard Shortcut: ASAP Utilities  › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Example screenshot: Change negative numbers to positive and vice versa (Here's the English version.)
Change negative numbers to positive and vice versa

Tip:Alt+P for the previous tool.