NFNP (Not Fixed Numeric Portion) spread function returns the numeric portion of a value with or without a qualifier and does no formatting to the number. Used to return the numeric portion of a result formatted as Not Fixed as text (string).
SYNTAX:
NFNP(Value/String)
Value/String: A quoted string, cell reference or spread function that returns text (i.e. VT function)
EXAMPLES:
NFNP("<2") - Returns 2
NFNP("14.3") - Returns 14.3
NFNP(A4) - Returns 0.21477 where cell A4 contains "e0.21477".
Qualifier(VT(4011,1,9999)) - Returns the numeric portion of the value returned by the VT function.
SEE ALSO: Qualifier, VAL