OCT2BIN

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

Syntax

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

Parameters

x

Required. The octal 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 octal 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

=OCT2BIN(5,3)
=OCT2BIN("777")

See Also

Function Reference
BIN2OCT Function
DEC2OCT Function
HEX2OCT Function