Convert Text to Numbers
Fix the green-triangle problem for a whole sheet at once. Text such as 1,250, 45% or $12.50 becomes a true number, and your file stays on your device.
- Free, no sign-up
- Files stay on your device
- Handles %, currency, commas
- IDs keep leading zeros
- Runs on your device. Files are never uploaded.
- Free and unlimited. No sign-up, no watermark.
Convert numbers stored as text in three steps
No account, no email, no waiting for an upload.
- STEP 01
Add your file
Add the sheet or CSV you want to change. Keep the sheet box blank to cover all sheets.
- STEP 02
Set the number style
Choose point or comma as the decimal mark, whether to remove currency signs and whether to protect leading-zero IDs.
- STEP 03
Download
The note says how many cells became numbers.
What Convert numbers stored as text does, and what it doesn't
We'd rather tell you up front than surprise you after the download.
What you get
- Many text stylesReads 1,234.56, 1.234,56, (1,234) as negative, -5, +5, 45% and values with $, €, £, ₹ and similar signs.
- Percentages done right45% becomes 0.45 with a percent format in Excel, so it still looks like 45%.
- Thousand separators shownValues written with grouping get a number format with thousands separators.
- IDs protectedValues like 00123 or PIN codes stay as text unless you turn the protection off.
- Formulas and dates untouchedOnly text cells are converted.
Good to know
- Long numbers stay textNumbers with more than 15 significant digits are left alone, because spreadsheets cannot store them exactly.
- CSV result is plain textA CSV has no number type. Converted values are written plainly, so 45% becomes 0.45 and 1,250 becomes 1250.
- Pick the right decimal mark1.234 means different things in different countries. Choose the decimal mark that matches your data.
Your spreadsheets never leave your device
The tool runs inside your browser instead of on our servers, so there is nothing to upload, store or delete afterwards.
Typical online tool upload
Your file travels over the internet, sits on someone else's computer for a while, and you wait for the upload and the download.
Mediaextractr no upload
The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.
When people use Convert numbers stored as text
Make SUM work again
Totals that show zero are usually text numbers.
Clean pasted prices
Remove currency signs from web-copied prices.
Handle European number styles
Convert 1.234,56 to a proper value.
Prepare data for import
Make numeric columns truly numeric before loading.
Mediaextractr vs typical upload tools
| MediaextractrPrivate | Typical upload tools | |
|---|---|---|
| Your file is uploaded | Never | Yes |
| Sign-up needed | No | Often, after a few files |
| Daily file limit | None | Often 1–2 free files |
| Watermark | Never | Sometimes |
| Wait for upload & download | No | Yes |
| Speed on very large files | Depends on your device | Depends on their servers |
Why numbers turn into text
Data copied from websites, PDFs and exports often arrives as text. A leading apostrophe, a stray space, a currency symbol or a thousands separator is enough for Excel to treat the value as a word. The tell-tale signs are left alignment and a small green triangle in the cell corner.
Settings that matter
Set the decimal mark first. With point selected, 1,234.50 is 1234.5. With comma selected, 1.234,50 is 1234.5. Keep the leading-zero option on for codes and phone numbers.
If stray spaces are the problem, clean them first with Trim Excel whitespace. Remove unwanted words from cells with Find and replace spreadsheet values. Afterwards you can check the columns with Spreadsheet column statistics.
Questions, answered
How do I convert text to numbers in Excel for a whole sheet?
Add the workbook, then download what comes out. All text that looks like a number is converted.
Does the file get uploaded to be converted?
No. The conversion is done in your browser.
Will leading zeros be lost?
Not by default. Values like 00123 stay as text. Turn that option off if you want them converted.
Does it understand percentages and currency?
Yes, 45% becomes 0.45 with a percent format, and currency signs can be stripped.
Does it work on CSV files?
Yes, but a CSV can only hold plain text, so numbers are written without formatting.
Does it run on Mac and mobile?
Yes, in current browsers.