Products, services, and OS functions
may not be available in this country.

OCT2BIN

The OCT2BIN function converts an octal number to the corresponding binary number.

OCT2BIN(octal-string, convert-length)

octal-string: The string value representing the number to be converted. octal-string must contain only the numbers 0 through 7.

convert-length: An optional number value specifying the minimum length of the number returned. convert-length must be in the range 1 to 32. If convert-length is omitted, it is assumed to be 1. If it is included, the number returned is padded with leading zeros, if necessary, so that it is at least the length specified by convert-length.

Examples

=OCT2BIN(127, 8) returns 01010111.

=OCT2BIN(15) returns 1101.

=OCT2BIN(-127, 8) returns an error, as the minus sign is not permitted.

See alsoBIN2OCTDEC2BINHEX2BINOCT2DECOCT2HEX
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.