DEC2OCT
Syntax:
DEC2OCT ( number [ , num-oct-digits ] )
Description: Makes the octal equivalent of number, with the result having num-oct-digits digits.
Arguments:
Name |
Type |
Description |
---|---|---|
number |
number |
The decimal number that is to be converted to an octal string. |
num-bin-digits |
number |
The number of digits in the result, with leading zeros added as necessary. However, if number is negative, num-oct-digits is ignored and the result has 10 digits. If num-oct-digits is omitted, the minimum number of digits is used in the result. num-oct-digits is truncated to an integer. |
Return Type and Value: text – The octal equivalent of number using twos-complement representation with the left-most bit (30th bit from the right) representing the sign bit.
However, if
number is outside the range
-536,870,912
(4000000000 octal) to536,870,911
(3777777777 octal), inclusive,#NUM!
is returned.number needs more digits that num-oct-digits,
#NUM!
is returned.num-oct-digits ≤ 0 or > 10,
#NUM!
is returned.