Negative Values

Excel internally represents octal numbers in binary using 30 bits.

The first bit indicates whether the number is positive or negative.

The remaining bits indicate the magnitude of the number.

Range of the DEC2OCT function.

For example, the DECIMAL function can convert the binary number 1101 into the decimal number 13.

Range of the DEC2OCT function.

Range of the DEC2OCT function.

Range of the DEC2OCT function.

Range of the DEC2OCT function.

Excel DECIMAL function

Range of the DEC2OCT function.