VALUE function

VALUE converts a text string into a number.

Syntax

VALUE (text)

text is the text to be converted to a number.

Example

=VALUE("4321") returns 4321.

Note: If the text string cannot convert to a number, VALUE returns #VALUE!.