PrecisionCalc
xl
Precision
Get Your Numbers Right

xlpISNUMBER

Determines whether a value or text string can be evaluated as a number by xlPrecision functions, with up to 32,767 significant digits of precision. Recognizes negatives, the local thousands separators (commas in English), exponential notation, and the local currency symbol.

Returns TRUE if input can be evaluated as a number by xlPrecision functions; returns FALSE if not.

Syntax

xlpISNUMBER(num)

 num Required. The value or text string to determine whether it can be evaluated as a number by xlPrecision functions.

Remarks

• num can accept both numbers and text.

• num can accept text formatted with the local currency symbol and thousands separators, and negatives can be formatted with either a leading hyphen or parentheses.

• num can accept text up to 32,767 characters long.

• If any xlPrecision edition other than the 32,767 SD edition is being used, number1 and number2 are rounded down to the maximum number of significant digits allowed by the edition in use.

Examples

 Formula Description Result =xlpISNUMBER(5) Determines whether 5 can be evaluated as a number by xlPrecision functions TRUE =xlpISNUMBER("123456789123456789123456789") Determines whether "123456789123456789123456789" can be evaluated as a number by xlPrecision functions TRUE =xlpISNUMBER("-1,234,567,891,234,567,891,234.56789") Determines whether "-1,234,567,891,234,567,891,234.56789" can be evaluated as a number by xlPrecision functions TRUE (In locales where the thousands separator is a comma, such as English.)FALSE (In locales where the thousands separator is not a comma, such as French and German, in which case spaces instead of commas would be recognized in French, or periods in German.) =xlpISNUMBER(1.234567890123456789012345E+12345) Determines whether "1.234567890123456789012345E+12345" can be evaluated as a number by xlPrecision functions TRUE (Recognized as a number in exponential notation -- 1.234567890123456789012345 to 12345 power.) =xlpISNUMBER("\$10") Determines whether "\$10" can be evaluated as a number by xlPrecision functions TRUE (In locales where the currency symbol is "\$".) FALSE (In locales where the currency symbol is not "\$".) =xlpISNUMBER("1.1.1") Determines whether "1.1.1" can be evaluated as a number by xlPrecision functions FALSE (Too many decimal characters.)