VALUE Function

The VALUE function is one of the text and data functions. Is used to convert a text value that represents a number to a number. If the converted text is not a number, the function will return a #VALUE! error.

Syntax

VALUE(text)

The VALUE function has the following argument:

Argument	Description
text	Text data that represents a number.

Notes

How to apply the VALUE function.

Examples

The figure below displays the result returned by the VALUE function.