Excel functions / Text

NUMBERVALUE function

Turns text into a number, whatever decimal and thousands marks it uses.

Syntax

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

Arguments

When to use it

NUMBERVALUE turns text into a number when the text uses a different decimal point or thousands separator from your own settings: a European "1.234,56" read on an English computer, for example. You tell it which character is which.

Examples

  1. A European amount

    ABC
    1Amount
    2'1.234,561234.56

    In C2: =NUMBERVALUE(A2, ",", ".") → 1234.56

    Try this example

  2. With spaces between the thousands

    ABC
    1Amount
    2'12 500,7512500.75

    In C2: =NUMBERVALUE(A2, ",", " ") → 12500.75

    Try this example

Common mistakes

NUMBERVALUE in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try NUMBERVALUE in the playground

Related functions