Tools Vault selection / Pro+ collection
Use Tool Finder if you do not know the ribbon group. Confirm the final location in your installed version.
Tool guide
Convert numbers stored as text
An export shows amounts, but formulas do not treat them as numbers.
What it solves
Use this when…
An export shows amounts, but formulas do not treat them as numbers.
Expected result: Numeric values that Excel can calculate with. Review unusual separators and negative amounts.
How to use
Follow these steps
Try the action on a copy of your workbook first.
1
Make a copy
Keep the original export so you can compare results.
2
Select the affected cells
Include only values you intend to convert, then locate Convert to Numbers.
3
Run and inspect
Check a few values, formulas and totals against the original.
Before you finish
Check the output
Confirm the result against the source and keep your own judgement in the loop.
Unexpected input format
Check headings, selected ranges and text/number formats before running. Work on a copy for consequential changes.
Next step
Keep learning
Related tools and workflows.
Smart Splitter
Separate values before converting them.
Explore ↗Ready to explore?
Make Excel work better for you.
Start with the current 10-day trial, or speak to us about what your team needs.