Home Screenshots 10 Languages Why use it?

Tip of the Day | Wednesday May 20th, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Convert Numbers Stored as Text to Real Numbers

Quickly fix numbers that Excel mistakenly treats as text in your selected cells and ensure they work correctly in formulas, sorting, and calculations.
This tool goes beyond Excel's built-in "Convert to Number" feature by addressing multiple issues at once.

How this tool fixes your data:

Clears leading and trailing spaces around numbers.

Fixes numbers with an apostrophe ('123) that prevents them from behaving like real numbers.

Removes leading zeros, cleans up numbers with unnecessary zeros (000123 → 123).

Recognizes fractions stored as text and converts text-based fractions (1/4, 1/2) into proper numeric values.

Changes cells with numbers or fractions and the number format "Text" to "General" or "Fraction".

Preserves long numbers like credit cards. Unlike Excel, it does not round or change long numbers such as credit card details.

Handles non-breaking spaces (char 160 /  ) that cause Excel to misinterpret numbers.

Fixes "empty" cells that aren't truly empty. Clears cells that contain only spaces, ensuring Excel treats them as blank.

Skips formulas and text, leaving existing formulas and text entries untouched.

Benefits compared to Excel's built-in "Convert to Number":

Works instantly without requiring manual error checking.

Fixes all your selected cells in one go.

Detects and corrects issues that Excel might miss.

By default, you can launch this tool using the Control+Alt+Shift+N shortcut.

Note:
This tool does not modify decimal- and thousand separators if they differ from your regional settings. If needed, use Excel's Find and Replace (Ctrl+H) to adjust thousand separators and decimal points before running this tool.

Screenshots

Numbers & Dates › Convert Numbers Stored as Text to Real Numbers

Starting this tool

Click ASAP Utilities › Numbers & Dates › 3. Convert Numbers Stored as Text to Real Numbers
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 ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Today's Tip

Download

©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.