Skip to content
ExcelExcel 2013+

NUMBERVALUE function in Excel

Converts text to number in a locale-independent manner

=NUMBERVALUE(Text, [Decimal_separator], [Group_separator ])

NUMBERVALUE syntax and parameters

Three arguments, one required.

  • TextstringRequired

    The text to convert to a number.

  • Decimal_separatorstringOptional

    The character used to separate the integer and fractional part of the result.

  • Group_separatorstringOptional

    The character used to separate groupings of numbers, such as thousands from hundreds and millions from thousands.

NUMBERVALUE examples

Formulas you'll actually reuse.

  1. A German-formatted amount into a number, whatever the workbook's locale:

    =NUMBERVALUE("1.250,75", ",", ".")

    Result1250.75

  2. A percentage with a comma decimal — the % sign is applied:

    =NUMBERVALUE("12,5%", ",")

    Result0.125

NUMBERVALUE in Google Sheets

No direct equivalent — here's the way around.

Try NUMBERVALUE in the playground

Edit the example — nothing to install.

Preloaded with the NUMBERVALUE formula from Example 1 — change anything and watch it respond.

Loading the editor…

NUMBERVALUE errors

What they mean — and the fixes.

  • #VALUE!

    The text has more than one decimal separator, or the decimal and group separators are the same character.

Related functions

More ways Excel gets this done.