BIN2OCT Function in Excel – Convert Binary to Octal in Excel

BIN2OCT Function in Excel converts Binary number to octal number.

Syntax of BIN2OCT Function in Excel (BINARY TO OCTAL FUNCTION IN EXCEL):

BIN2OCT(number,[places])

Where

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

Example of BIN2OCT Function in Excel (BINARY TO OCTAL FUNCTION IN EXCEL):

Formula:

BIN2OCT Function in Excel 1

The supplied binary value should not have more than 10 character
In row number 4, BIN2OCT Function takes up [places] argument as 6 which returns the 6 digits with 4 preceding Zeros i.e. 000025.

Result:

BIN2OCT Function in Excel 2

Note:

#NUM! – Error occurs if the supplied number argument is not recognized as a binary number, or contains more than 10 characters.