Google Sheets-functie

NUMBERVALUE

Converts text to a number in a locale-independent way.

Formule genereren met AI Dezelfde functie in Excel

Deze functie werkt in Google Spreadsheets hetzelfde als in Excel — dezelfde syntaxis en argumenten.

Syntaxis

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

The NUMBERVALUE function converts text to a number by allowing you to specify custom decimal and group separators. This is particularly useful when importing data from different regions where number formatting conventions vary.

Argumenten

textvereistThe text string to convert to a number.
decimal_separatoroptioneelThe character used to separate the integer and fractional parts.
group_separatoroptioneelThe character used to separate groups of numbers, such as thousands.

Voorbeelden

=NUMBERVALUE("1.234,56", ",", ".")

Resultaat: 1234.56

Converts a European-formatted number string using a comma as a decimal separator into a standard numeric value.

Veelgestelde vragen

Why use NUMBERVALUE instead of VALUE?

NUMBERVALUE is locale-independent and allows you to define custom separators, whereas VALUE relies on the system's regional settings.

Gerelateerde functies

VALUE TEXT SUBSTITUTE