The VALUE function converts a text representation of a number into an actual number. It is a simple, obscure function that is provided primarily for compatibility with other spreadsheet programs.

VALUE takes 1 required argument and no optional arguments:

Syntax: VALUE(text)

#1)
Using the VALUE function:
#2)
The arguments for the VALUE function are:
Argument Required? Description
text Required The text enclosed in quotation marks or a reference to a cell containing the text you want to convert.

Summary

The VALUE function converts a text representation of a number into an actual number and is provided primarily for compatibility with other spreadsheet programs.
comments powered by Disqus