Excel DEC2OCT Function

Using the Excel DEC2OCT Function


The Excel DEC2OCT function converts a decimal number to an octal.


=DEC2OCT (number, [places])

Syntax Breakdown

Required. The number, in decimal format, that you wish to convert to octal. Negative numbers are represented using two's-complement notation. If the number argument is negative, the places argument will be ignored and the function will return a 10 character (30 bit) octal number.

Optional. The number of characters to be used. If omitted, the function uses the minimum number of characters necessary. If the input is not an integer, it will be truncated.

Usage Notes

DEC2OCT converts a number from decimal format to its octal equivalent.

DEC2OCT Errors
The function will return an error in the following instances:

1) The #NUM! error if places is negative

2) The #VALUE! error if places in non-numeric

3) The #NUM! error if number is < -536,870,912 or > 536,870,911

4) The #VALUE! error if number is non-numeric

5) The #NUM! error if not enough places are provided