<< Click to Display Table of Contents >> VALUE (convert text into a number)

Syntax:

VALUE(Text)

Description:

Converts a text string into a number.

Text is the text string to convert. It must contain the text representation of a number, otherwise a #VALUE! error value is returned.

Note:

This function was retained only for compatibility with older spreadsheet applications. It is no longer commonly used, as current spreadsheet applications (including PlanMaker) automatically convert text strings into numbers, where necessary.

Example:

VALUE("42") returns 42

VALUE("42 USD") returns 42, since "USD" is a valid currency unit.

VALUE("42 bolts") returns a #VALUE! error value.

VALUE("TRUE") returns 1

VALUE("09/25/2014") returns 41907, the serial date value for the date 09/25/2014.

See also:

NUMBERVALUE, TEXT, T, N