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

The BIN2OCT function converts a binary number to octal.

Formula in cell B3:


Excel Function Syntax



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).


Maximum binary values are 10 characters.