| | | This function is only available if you have the Analysis ToolPak add-in installed. |
| | | The "number" may not contain more than 10 characters. The most significant bit of number is the sign bit. The remaining 29 bits are magnitude bits. |
| | | If "number" is not a valid octal number, then #NUM! is returned. |
| | | If "number" contains more than 10 characters (10 bits), then #NUM! is returned. |
| | | If "number" < 0, then "places" is ignored and returns a 10-character binary number. |
| | | If "number" < 0, it cannot be less than or equal to 7777777000, and if number is positive, it cannot be greater than 777. |
| | | If "places" is not an integer, it is truncated. |
| | | If "places" is not numeric, then #VALUE! is returned. |
| | | If "places" < 0, then #NUM! is returned. |
| | | If "places" is left blank, then the minimum number of characters necessary is used. Places is useful for padding the return value with leading 0s (zeros). |
| | | If "places" is not enough characters, then #NUM! is returned.. |
| | | Any negative numbers are represented using two's complement notation. |
