Class Value

  • All Implemented Interfaces:
    ArrayFunction, Function, Function1Arg

    public final class Value
    extends Fixed1ArgFunction
    implements ArrayFunction
    Implementation for Excel VALUE() function.

    Syntax:
    VALUE(text)

    Converts the text argument to a number. Leading and/or trailing whitespace is ignored. Currency symbols and thousands separators are stripped out. Scientific notation is also supported. If the supplied text does not convert properly the result is #VALUE! error. Blank string converts to zero.