Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
NUMBERVALUE
NUMBERVALUE parses a number stored as text that uses non-standard decimal or thousands separators (such as European formats using commas as decimals) and converts it to a true numeric value. Use it when importing data from international sources or systems that format numbers differently from your spreadsheet locale.
Excel
=NUMBERVALUE(A2,",",".")Google Sheets
=NUMBERVALUE(A2,",",".")Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Identify the text string containing the number with its non-standard separators.
- 2Determine the decimal separator and group (thousands) separator characters used in the source text.
- 3Enter =NUMBERVALUE(text, decimal_separator, group_separator) to obtain a numeric result suitable for calculations.
Need a version for your data?
Try: “Convert European-format numbers like '1.234,56' to a numeric value Excel can calculate with”