Formulas and Functions

Chapter 11 Text Functions 325
VALUE
The VALUE function returns a number value even if the argument is formatted as
text. This function is included for compatibility with tables imported from other
spreadsheet applications.
VALUE(source-string)
 source-string: A string. source-string is a string value.
Usage Notes
You’ll never need to use the VALUE function in a new table, as numbers in text are Â
automatically converted for you.
Only the formatted text is converted. For example, if the string $100.001 is typed into Â
a cell, the default format will display only two decimals ($100.00). If VALUE refers to
this cell, it will return 100, the value of the formatted text, not 100.001.
If the argument can’t be returned as a number value (does not contain a number), Â
the function returns an error.
Examples
=VALUE(”22”) returns the number 22.
=VALUE(RIGHT(”The year 1953”, 2)) returns the number 53.
Related Topics
For related functions and additional information, see:
“Listing of Text Functions” on page 306
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41