DEC2OCT Function in Excel – Convert Decimal to Octal in Excel

DEC2OCT Function in Excel converts Decimal number to Octal number.

Syntax of DEC2OCT Function in Excel (DECIMAL TO OCTAL FUNCTION IN EXCEL):

Where

• number – The Decimal number that is to be converted to Octal.
• [places] –  An optional argument that specifies how many digits needs to be returned.

 

Example of DEC2OCT Function in Excel (DECIMAL TO OCTAL FUNCTION IN EXCEL):

Formula:

• In row number 2, DEC2OCT Function takes up [places] argument as 8 which returns the 8 digits with 6 preceding Zeros i.e. 00000016.

Result:

Note: #NUM! – Error occurs

• If the supplied number argument is greater than 511 or less than -512
• If the supplied [places] argument is less than 0 and greater than 10.