VALUE

This function takes a text representation of a number that is formatted in the current culture and returns a numeric value.

Syntax

=VALUE("text_value")

In this example the current culture is English (neutral).

Cell C14 contains this text representation of a numeric value: 12,346.

Cell D14 contain this formula: =VALUE(C14).

The formula returns 12346.