Tip of the Day | Friday 16 October 2026

This tool fixes numbers with the minus sign at the end and moves it to the front so Excel recognizes them as negative numbers.
For example, it converts "250-" into "-250", making the value usable in calculations and formulas.

This is particularly useful when handling imported data from accounting or financial systems that format negative numbers with a minus sign at the end.

This tool is a quicker and easier alternative to using Excel's "Text to Columns" feature with the "Trailing minus for negative numbers" option under advanced settings.

Starting this tool