NUMBERVALUE

TextExcel 2016

Convert text to a number with explicit decimal / thousands separators.

Syntax

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

How it works

Use when data uses separators that differ from your locale (e.g. "1.234,56" from a European export).

Examples

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

→ 1234.56

Related functions

VALUE TEXT

More Text functions

ARRAYTOTEXT ASC BAHTTEXT CHAR CLEAN CODE CONCAT CONCATENATE DBCS DOLLAR EXACT FIND

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.