NUMBERVALUE

Excel Functions

Convert text to number with custom separators

Syntax

EXCEL

=NUMBERVALUE(text, [decimal_separator], [group_separator])

Arguments

Parameter	Description
`text`	The text to convert to a number.
`decimal_separator`	[optional] The character for decimal values.
`group_separator`	[optional] The character for grouping by thousands.

Return Value

Numeric value

Details

The NUMBERVALUE function converts a text value representing a number into a valid numeric using custom decimal and group separators. You can use NUMBERVALUE to translate numbers from a locale-specific text format into a locale-independent number. To perform a numeric conversion, the NUMBERVALUE function uses the custom separators you provide. The decimal_separator is the character used to separate integers from fractional values in the source text. The group_separator is the character used to group text by thousands in the source text. Both separators should be enclosed in double quotes (""). When decimal_separator and group_separator, Excel uses separators for the current locale. To convert the text string "10,15" to the number 10.15: To convert the text value "5%" to a number with no gro

Examples

To convert the text string "10,15" to the number 10.15:

EXCEL

=NUMBERVALUE("10,15",",") // returns 10.15

Examples

To convert the text value "5%" to a number with no grouping or decimal separator:

EXCEL

=NUMBERVALUE("5%") // returns 0.05

Examples

To convert the string "6.000" to the number 6000, where the grouping separator in the source text is a period (.) use:

EXCEL

=NUMBERVALUE("6.000",",",".") // returns 6000

Examples

In the example shown, input text is in column B and function output is in column E. Columns C and D are the decimal and group separators used in each

EXCEL

=NUMBERVALUE(B6,C6,D6)

NUMBERVALUE

Syntax

Arguments

Return Value

Details

Examples

See Also