ajBigNumNumberValue function
Description
Returns the value of number as an Excel number value.
Syntax
ajBigNumNumberValue(number)
| Argument Name | Argument Type | Description |
|---|---|---|
| number (required) | String | A number in number or string format. For example, -1 or "-1". |
The function will return:
1) Return Value: Number
2) Return Type: Single Value
Example
Example 1
=ajBigNumNumberValue("12345")
The function returns 12345 in number format.
Example 2
When the length of number more than 11, it will show the value in scientific notation format.
=ajBigNumNumberValue("1234567890123")
The function returns 1.23457E+12.
Error Scenarios
It will return #VALUE! when missing any required parameter or mismatch parameter type. Besides, system will raise error for below scenario(s).
| Error Scenario |
|---|
| Number is neither a number or a string that can be converted to a number. |