Convert an octal number into a binary number.

`=OCT2BIN(number,[places])`

- Number - The octal number to convert to binary
- Places [OPTIONAL] - The number of characters in the returned binary number

`=OCT2BIN( "5" )`

The formula converts the octal number 5 to a binary number. The result is 101, as 5 in octal is equivalent to 5 in binary.

`=OCT2BIN( "0000000001" )`

The formula converts the octal number 01 to a binary number. The result is 1, as 01 in octal is equivalent to 1 in binary.

`=OCT2BIN( "2", 10 )`

The formula converts the octal number 2 to a binary number with 10 places. The result is 0001000000, as 2 in octal is equivalent to 32 in binary, which is 10 places when padded with 0s.

`=OCT2BIN( "7777777770" )`

The formula converts the octal number 7777777770 to a binary number with 10 places. The result is 1111111110, as 7777777770 in octal is equivalent to 4294967294 in binary, which is 10 places when padded with 0s.

`=OCT2BIN( "16" )`

The formula converts the octal number 16 to a binary number with 10 places. The result is 0100000000, as 16 in octal is equivalent to 512 in binary, which is 10 places when padded with 0s.

The OCT2BIN function in Sourcetable converts an Octal number into a binary number. The number argument is required, and the places argument is optional.

- The OCT2BIN function converts an Octal number into a binary number.
- The arguments for the OCT2BIN function are number (required) and places (optional).
- The OCT2BIN function returns a binary number that is at least as many places as specified by the places argument.

The OCT2BIN function is a Sourcetable function that converts an octal number to a binary number.

The OCT2BIN function takes two arguments:

- Number (required)
- Places (optional)

The OCT2BIN function returns a 10-character binary number if the number is negative. If the places argument is negative, then the function will return a #NUM! error.

Drop CSV