You can convert octal numbers into binary numbers
The binary numbers contain only 0 and 1 values
Octal numbers contain 0 to 7 values
OCT2BIN Function has a limit of 777 octal numbers
If you write more than 777 characters it will return #NUM error

Syntax of OCT2BIN Function

Argument of OCT2BIN Function

Number: it is the number you want to convert into octal
Places:[Optional] how many characters you want to show in your result. It will place "0" before the result.

Behavior of OCT2BIN Function

Here we have taken an example of the octal number and convert it into binary numbers.
We have written a formula  
=OCT2BIN(D4,10) which will convert the binary number into octal and show result till 10 characters. No character place is fill by 0
On the right side, if you write 777 it will return 9 times "1"
If you write 778 it will return #NUM error because in banary number it becomees 10 charecter
Usage of OCT2BIN Function

To convert an Octal number into a Binary number

Returns of OCT2BIN Function

Binary number

You can solve your engineering problem by using simple Excel formulas and functions


BIN2DEC    Converts Binary number system to Decimal number system
BIN2HEX    Converts Binary number system to Hexa Decimal number system
BIN2OCT    Converts Binary number system to Octal number system
DEC2BIN    Converts Decimal number system to Binary number system
DEC2HEX   Converts Decimal number system to Hexa Decimal number system
DEC2OCT   Converts Decimal number system to Octal number system
OCT2BIN    Converts Octal number system to Binary number system
OCT2DEC   Converts Octal number system to Decimal number system
OCT2HEX   Converts Octal number system to Hexa Decimal number system
HEX2BIN    Converts Hexa Decimal number system to Binary number system
HEX2OCT   Converts Hexa Decimal number system to Octal number system
HEX2DEC   Converts Hexa Decimal number system to Decimal number system

BITAND         Bitwise AND Operation
BITOR            Bitwise OR operation
BITXOR         Bitwise Exclusive OR Operation
BITLSHIFT    Bitwise Shift LEFT Operation
BITRSHIFT    Bitwise Shift RIGHT Operation

CONVERT     Converts one unit to another unit