NUMBERVALUE function
Conversion — text to number in a locale-independent manner.
Text · Excel 2013+
Where can you use it?
Data preparation and reporting teams. Use this group to clean, split or reformat IDs, names and descriptions before using them in reports.
Scenario in the workbook
Specify the thousands period and decimal comma explicitly. The result is a numeric value you can use in calculations.
A worked example from the workbook
| Row | A |
|---|---|
| 6 | Input |
| 7 | 1.234,50 |
| 8 | 1.002,25 |
| 9 | -2.001,75 |
Record 1
=NUMBERVALUE(A7,",",".")Expected result1234.5
See the inputs and instructions for all 3 examplesCopyable formulas
English Excel · en-US
=NUMBERVALUE("12,50",",",".")Turkish Excel · tr-TR
=SAYIDEĞERİ("12,50";",";".")Expected result
12.5
Worked examples
Specify the thousands period and decimal comma explicitly. The result is a numeric value you can use in calculations.
Use the blue inputs in the table starting at A6. F7:F9 calculate results and G7:G9 retain the original values for comparison.
| Row | A |
|---|---|
| 6 | Input |
| 7 | 1.234,50 |
| 8 | 1.002,25 |
| 9 | -2.001,75 |
| Trial | Expression | Sample output |
|---|---|---|
| Record 1 | =NUMBERVALUE(A7,",",".") |
1234.5 |
| Record 2 | =NUMBERVALUE(A8,",",".") |
1002.25 |
| Record 3 | =NUMBERVALUE(A9,",",".") |
-2001.75 |