Convert numbers stored as text
A number stored as text does not add up, does not sort and breaks lookups. The tool reads numbers with a decimal point or a decimal comma, with their currency symbols, thousands separators and accounting negatives, and says which ones it could not read.
What this tool does
- The decimal point or comma, detected column by column, or set by you.
- Thousands separators, €, $ and £ symbols, percentages.
- Negatives in brackets (accounting) and with a trailing minus (SAP exports).
- Codes with leading zeros and numbers longer than fifteen digits stay text.
- Cells that could not be read are counted and shown, and left as they are.
What it does not do: A number a spreadsheet already rounded (beyond fifteen digits) does not get its lost digits back. An ambiguous value such as "1.234" is read according to the column's convention: check the preview.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Fix a CSV file : Broken accents, everything in one column, lost zeros: a file Excel opens right the first time.
- Remove duplicates : On the columns you choose, optionally ignoring case, spaces and accents.
- Near-duplicates : "Smith Ltd" and "SMITH LTD.": the almost-identical duplicates, reviewed one by one.
- Clean text : Extra spaces, non-breaking spaces, line breaks, invisible characters, case.
- Fix dates : Dates as text, day and month swapped, "20260315": real dates.