BIN2OCT |
| BIN2OCT(number, places) |
Returns the number converted from binary to octal. |
| number | The binary number you want to convert. |
| places | The number of characters to use. |
| REMARKS |
| * If "number" contains more than 10 characters (10 bits). The most significant bit of number is the sign bit. The remaining 9 bits are magnitude bits. * If "number" contains 10 characters then the most significant bit (i.e. the first number) represents the sign bit (i.e. either positive or negative). * If "number" contains more than 10 characters (10 bits), then #NUM! is returned. * If "number" < 0 then two's-complement notation is used to represent the number. * If "number" < 0, then "places" is ignored and a 10-character octal number is returned. * If "number" is not a valid binary number, then #NUM! is returned. * If "places" is less than the number of characters needed, then #NUM! is returned. * If "places" is left blank, then the minimum number of characters necessary. * 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. * The "places" is useful for padding the return value with leading 0s. * You can use the BIN2DEC function to convert a number from binary to decimal. * You can use the BIN2HEX function to convert a number from binary to hexadecimal. * You can use the OCT2BIN function to convert a number from octal to binary. * The equivalent VBA function is VBA.OCT * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com |
|
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top