How to convert a text string into a number In Excel | NUMBERVALUE Function Explained With Examples

NUMBERVALUE

The NUMBERVALUE Function is categorized under Excel TEXT functions.
It will convert a text string into a number in a locale-independent manner.

The function was added in MS Excel 2013 and is available in all subsequent Excel versions
but not available in earlier versions.



Formula
=NUMBERVALUE(Text,[decimal_separator],[group_separator])



The NUMBERVALUE function uses the following arguments:

Text (required argument) – This is the text that will be converted into a number.
Decimal_separator (optional argument) – The character used to separate the integer and fractional part of the result.
Group_separator (optional argument) – Is used to separate groupings of numbers, such as separating millions from thousands, thousands from hundreds, etc.

__________________________________________________________________________________________________

You can follow us on the below social media handles:-