Text
NUMBERVALUE
Number from text with the given separators, e.g. "1,250.75" from a CSV.
Syntax
NUMBERVALUE(text, [decimal_separator], [group_separator])Example: =NUMBERVALUE("1,250.75",".",",")
Available in: Excel 2013+
Try it
A tiny spreadsheet with example data. Edit the formula or any number and see the result.
Formula in D2: =NUMBERVALUE("1,250.75",".",",")
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Text | Other | Result | |
| 2 | Alice Johnson | alice johnson | 1250.75 | |
| 3 | [email protected] | [email protected] | ||
| 4 | extra spaces | |||
| 5 | SKU-2026-0415 | |||
| 6 | iced coffee, tea, sugar | |||
| 7 | Order 417 shipped |
Result in D2: 1250.75