Author: Oscar Cronquist Article last updated on March 28, 2018

The BIN2OCT function converts a binary number to octal.

Formula in cell B3:

=BIN2OCT(11001)

Excel Function Syntax

BIN2OCT(number,[places])

Arguments

number Required. The binary number you want to convert to octal.
[places] Optional. The number of characters to use. If not entered the minimum number of characters is used. Use this argument to add leading 0 (zeros).

Comments

Maximum binary values are 10 characters.