Tip of the Day | Sunday May 12th, 2024
Discover new tools to get things done.
Convert unrecognized numbers (text?) to numbers
This utility changes the numbers that behave like text to real numerical numbers which Excel recognizes.You might have experienced that sometimes Excel treats numbers as text; they are left aligned, they don't work in your formulas or don't sort properly.
This problem often occurs when data is imported or copied from other programs.
This utility will also help you get errors in your =VLOOKUP() formulas because Excel treats the numbers as text and therefore can't find a matching value.
You can also use this utility to remove leading zeros from numbers or to make Excel recognize empty cells properly as empty again.
Note:
This utility does not convert numbers with decimal separators different then specified in the language settings in MS Windows or in the "International" options of your workbook.
For example often people in The Netherlands have problems with imported text files when the numbers are stored as for example "120.00" where a point is used as decimal separator instead of a comma.
In such a case you can use Excel to replace (Ctrl+H) the point (or whatever) to your decimal separator to have Excel recognize the numbers correctly.
Screenshots
Starting this tool
- Click ASAP Utilities › Numbers & Dates › 3. Convert unrecognized numbers (text?) to numbers
- Specify a Keyboard Shortcut: ASAP Utilities › Favorites & Shortcut keys › Edit your favorite tools and shortcut keys...
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
©1999-2024 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
Empowering Excel Users Worldwide for 25 Years
Empowering Excel Users Worldwide for 25 Years