SheetXL - v0.3.20
    Preparing search index...
    • Converts a given value to a number, returning 0 if the value cannot be parsed as a valid finite number.

      The function first attempts to coerce the value into a number using parseAsNumber. If the resulting number is NaN or Infinity, the function returns 0. Otherwise, it returns the parsed number.

      Parameters

      • value: any

        The value to be converted to a number.

      Returns number

      The parsed number if it's finite, otherwise 0.

      asNumber("123");    // 123
      asNumber("abc"); // 0
      asNumber(null); // 0
      asNumber("12.34"); // 12.34
      asNumber(Infinity); // 0