Author: Oscar Cronquist Article last updated on April 07, 2018

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

Formula in cell D3:

=DEC2OCT(B3,C3)

Excel Function Syntax

DEC2OCT(number, [places])

Arguments

number Required. The decimal integer you want to convert.
[places] Optional. The number of characters to use. If not entered the function uses the number of characters needed to complete the task. This argument allows you to add leading 0s (zeros).

Comments

The octal numeral system has a base of 8. For example 0 to 7 is zero to seven however 8 in the decimal system is ten in the octal system.