Convert Text to Numbers Online

Strip currency symbols, commas, and spaces so text-formatted numbers become real numbers.

100% private. Everything runs in your browser. Your data never leaves your device.

Text to Numbers

What does this tool do?

This tool converts text-formatted numbers into real numbers by stripping currency symbols, thousands separators, and spaces. It fixes the common Excel problem where numbers imported as text will not sum or calculate. Runs in your browser.

How to use Convert Text to Numbers - Free Online Tool

  1. Paste your values (one per line), or click "Try with sample data".
  2. The tool detects and cleans currency symbols, commas, and spaces.
  3. Click Convert.
  4. Copy or download clean numeric values.

Example

Cleaning text-formatted amounts:

Before

Text
$1,250.50
₹ 2,000

After

Number
1250.50
2000

Symbols and separators are removed, leaving real numbers.

Excel formula alternative

Prefer a formula? You can achieve a similar result with VALUE:

=VALUE(SUBSTITUTE(SUBSTITUTE(A2,"$",""),",",""))

Excel needs VALUE plus SUBSTITUTE to clean text numbers. This tool cleans the whole list in one step.

When should I use this tool?

Fixing "numbers stored as text" warnings
Cleaning imported financial data
Preparing amounts for SUM and calculations
Stripping currency symbols
Removing thousands separators
Standardizing numeric columns

Frequently Asked Questions

They are likely stored as text. This tool strips the formatting so they become real numbers that calculate correctly.

No. Conversion runs in your browser.

Yes. Common currency symbols and thousands separators are removed.

Yes. Decimal points are kept while separators and symbols are removed.

Related tools

Remove Special Characters
Trim, Clean & Convert Case
Extract Numbers from Text
Format Data
Excel Formula Generator

Related Tools

Compare Excel Files Excel Formula Generator Merge Excel Workbooks Trim, Clean & Convert Case Remove Duplicates Compare Two Excel Columns Excel ↔ JSON Converter Excel ↔ XML Converter EMI Calculator Age Calculator Excel ↔ CSV Converter Split Excel Sheets Remove Blank Rows/Columns Format Data Income & Expense Tracker Find Duplicates Split Text (Text to Columns) Extract Email Addresses Extract Numbers from Text Word & Character Counter Change Text Case Find & Replace Text Combine Columns Remove Special Characters Add Prefix / Suffix Reverse Text Split Full Names Remove Extra Spaces Extract URLs Extract Text Between Characters Add Serial Numbers Transpose Data Sort Data Delete / Keep Columns CSV Viewer CSV to JSON JSON to CSV CSV to SQL CSV to Markdown Table Markdown Table to CSV Excel / CSV to HTML Table Count Unique Values Data Profiler & Health Check Percentage Calculator Percentage Change Calculator Profit Margin Calculator CAGR Calculator Discount Calculator GST Calculator