Compatibility
Excel 2007 (Compatibility)
◉ 24 views
=NUMBERVALUE()
Converts text to a number, in a locale-independent way.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=NUMBERVALUE(Text, [Decimal_separator], [Group_separator ])
Hover argument names in the table for details.
Output typeNumber
Popularity14 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =NUMBERVALUE() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
🧠 🧠 Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
text |
Text | Required | The text to convert to a number. |
decimal_separator |
Text | Optional | The character used to separate the integer and fractional part of the result. |
group_separator |
Text | Optional | The character used to separate groupings of numbers, such as thousands from hundreds and millions from thousands. |
▣ Examples
Returns 2,500.27. The decimal separator of the text argument in the example is specified in the second argument as a comma, and the group separator is specified in the third argument as a period.
=NUMBERVALUE("2.500,27",",",".")
Result:
2500.27
Returns 0.035. Because no optional arguments are specified, the decimal and group separators of the current locale are used. The % symbol is not shown, although the percentage is calculated.
=NUMBERVALUE("3.5%")
Result:
0.035
§ Remarks
- If the Decimal_separator and Group_separator arguments are not specified, separators from the current locale are used.
- If multiple characters are used in the Decimal_separator or Group_separator arguments, only the first character is used.
- If an empty string ("") is specified as the Text argument, the result is 0.
- Empty spaces in the Text argument are ignored, even in the middle of the argument. For example, " 3 000 " is returned as 3000.
- If a decimal separator is used more than once in the Text argument, NUMBERVALUE returns the #VALUE! error value.
- If the group separator occurs before the decimal separator in the Text argument , the group separator is ignored.
- If the group separator occurs after the decimal separator in the Text argument, NUMBERVALUE returns the #VALUE! error value.
- If any of the arguments are not valid, NUMBERVALUE returns the #VALUE! error value.
- If the Text argument ends in one or more percent signs (%), they are used in the calculation of the result. Multiple percent signs are additive if they are used in the Text argument just as they are if they are used in a formula. For example, =NUMBERVALUE("9%%") returns the same result (0.0009) as the formula =9%%.
✦ Tips
- If the Decimal_separator and Group_separator arguments are not specified, separators from the current locale are used.
- If multiple characters are used in the Decimal_separator or Group_separator arguments, only the first character is used.
- If an empty string ("") is specified as the Text argument, the result is 0.
- Empty spaces in the Text argument are ignored, even in the middle of the argument. For example, " 3 000 " is returned as 3000.
- If the group separator occurs before the decimal separator in the Text argument , the group separator is ignored.
- If the Text argument ends in one or more percent signs (%), they are used in the calculation of the result. Multiple percent signs are additive if they are used in the Text argument just as they are if they are used in a formula. For example, =NUMBERVALUE("9%%") returns the same result (0.0009) as the formula =9%%.
⚠ Common Errors
#VALUE!
If a decimal separator is used more than once in the Text argument, NUMBERVALUE returns the #VALUE! error value. If the group separator occurs after the decimal separator in the Text argument, NUMBERVALUE returns the #VALUE! error value. If any of the arguments are not valid, NUMBERVALUE returns the #VALUE! error value.
Fix: Use text with the specified separators
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!