NUMBERVALUE
Converts text to number in a locale-independent manner.
TextText CleaningText Processing
What it does
Converts text to number with specified decimal/group separators.
Syntax
NUMBERVALUE(text, [decimal_separator], [group_separator])
Arguments
text(text) — Text string.decimal_separator(text) — Decimal char.group_separator(text) — Group char.
Examples
Parse Number
Parse '1.234,56' (EU style).
FORMULA
=NUMBERVALUE("1.234,56", ",", ".")RESULT
1234.56
SAMPLE DATA
| A | |
|---|---|
| 1 | Text |
| 2 | 1.234,56 |