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

Syntax:

VALUE(Text)

Description:

This converts a text string into a number.

Text is the text string to be converted. 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 if necessary.

Example:

VALUE("42") returns 42

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

VALUE("42 screws") 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