Tip of the Day | Saturday February 21st, 2026
Discover new tools to get things done.
Fix Trailing Minus Sign: e.g., Convert 50- to -50
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.
Screenshots
Starting this tool
- Click ASAP Utilities › Numbers & Dates › 7. Fix Trailing Minus Sign: e.g., Convert 50- to -50
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.