| | | This function is only available if you have the Analysis ToolPak add-in installed. |
| | | Number may not contain more than 10 octal characters (30 bits). The most significant bit of number is the sign bit. The remaining 29 bits are magnitude bits. Negative numbers are represented using two's-complement notation. |
| | | If "number" < 0, OCT2HEX ignores places and returns a 10-character hexadecimal number. |
| | | If "number" is not a valid octal number, then #NUM! is returned. |
| | | 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. Places is useful for padding the return value with leading 0s (zeros). |
| | | If "places" is not enough characters, then #NUM! is returned. |
