VALUE

See also A-Z Spreadsheet Function List

Description Returns the specified text as a number.

Syntax VALUE(text)

text is any text string, a formula that evaluates to a text string, or a cell reference that contains a text string. You can also specify a date or time in a recognizable format (e.g., M/DD/YY for dates or H:MM AM/PM for time). If the format is not recognized, #VALUE! is returned.

See Also DOLLAR , FIXED , and TEXT functions

Examples VALUE(9800) returns 9800

         VALUE(“123”) returns 123