BIN2OCT

Converts the specified binary (base 2) number to its octal (base 8) equivalent.

Syntax

BIN2OCT( NumberOrText x, [Integer digits] ) → Text

Parameters

x

Required. The binary number to convert, expressed as either text or number. This value should not contain more than 10 characters.

digits

Optional. The number of characters to use for the result, useful for padding the return value with leading zeros.

Remarks

If x is not a valid binary number, the function returns the #VALUE! error value. If x contains more than 10 characters (10 bits), the function returns the #NUM! error value.

If digits is omitted, the function uses the minimum number of characters necessary to represent the result. If digits is specified and is less than the number of characters required to represent the result, the function returns the #NUM! error value. If digits is not an integer number, it is truncated.

Example

Formula

=BIN2OCT(100100)
=BIN2OCT("1101001")

See Also

Function Reference
BIN2DEC Function
BIN2HEX Function
DEC2HEX Function
HEX2BIN Function
OCT2BIN Function