DataMimiDataMimi

Convert text to numbers in Excel

Turn $1,250.00, 12% and 03/15/2026 typed as text into real numbers and dates you can sum and sort.

Want it to work exactly your way?

Keep this tool in your Mini-Apps to run it again in one click, or describe the job and AI builds an app of your own.

✦ Make your own app

How to use Fix numbers stored as text

  1. 1Select your file, or drop it on the page
  2. 2Run it — nothing to set up
  3. 3Download fixed.xlsx

Your file is opened in an isolated sandbox with no internet access, processed and deleted with it. It is read the way people's spreadsheets really are — headers that are not on row 1, merged cells, totals pasted at the bottom, dates in two formats — and everything that is changed is listed back to you.

Questions

Why won't Excel add up my numbers?

Because they are stored as text — usually from an export or a copy-paste that kept the dollar sign, the thousands comma or a trailing space. Excel shows them like numbers but SUM skips them. This tool converts the whole column to real numbers.

Which columns does it change?

Only columns where most filled cells read as a number or a date. Order numbers, ZIP codes, phone numbers and other identifiers made of digits are recognised and left as text, so leading zeros are not lost.

What happens to a cell it cannot read, like 'N/A'?

It becomes blank rather than zero, so it cannot quietly lower a total — and the column is listed back to you with an example of what was converted.

Does it handle 1.250,00 as well as 1,250.00?

Yes. The separator is decided per column from the values themselves, so a column written with full stops for thousands is read correctly instead of being off by a factor of a thousand.

More Excel tools

See all