Converts a decimal number to an octal number.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
DEC2OCT(number, [places])The DEC2OCT function converts a decimal integer to its octal equivalent. If the number is negative, the function returns a 10-character two's complement octal number.
=DEC2OCT(56)Result: 70
Converts the decimal number 56 to octal.
=DEC2OCT(10, 4)Result: 0012
Converts 10 to octal with a fixed length of 4 characters.
The number must be between -536,870,912 and 536,870,911.