NUMBERVALUE

Converts text to a number, locale-independent.

Excel: Not checked yet
Google Sheets: No equivalent
Returns: Number

Examples

=NUMBERVALUE("2.5")

Result 2.5

Syntax

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

text: text required
decimal_separator: text optional
group_separator: text optional

Errors

#VALUE!: =NUMBERVALUE("alpha")

ASCConverts full-width characters to half-width. BAHTTEXTSpells a number as thai baht and satang. CHARReturns the character for a character-set code. CLEANRemoves non-printable characters. CODENumeric code of the first character. CONCATJoins multiple text strings into one.