| | | This function is only available if you have the Analysis ToolPak add-in installed. |
| | | If any of the arguments are not numeric, then #VALUE! is returned. |
| | | If "number" < -549,755,813,888, then #NUM! is returned. |
| | | If "number" > 549,755,813,887, then #NUM! is returned. |
| | | If "number" < 0, "places" is ignored and a 10-character (40-bit) hexadecimal number in which the most significant bit is the sign bit is returned. The remaining 39 bits are magnitude bits. |
| | | If "number" < 0, then two's-complement notation is used to represent the number. |
| | | If "places" is not an integer, it is truncated. |
| | | If "places" < 0, then #NUM! is returned. |
| | | If "places" is left blank, then the minimum number of characters necessary is used. |
| | | The "places" is useful for padding the return value with leading 0s. |
| | | If "places" is less than the number of characters needed, then #NUM! error value. |
