OCT2BIN Function Explained

The OCT2BIN Function in Microsoft Excel converts an octal number to a binary number. It takes one argument, a number in octal format, and returns the equivalent binary number. The octal number must be within the range of -549,755,813,888 to 549,755,813,887.

OCT2BIN Function Syntax

OCT2BIN(number, [places])

  • number: The octal number you want to convert.
  • places: (optional) The number of characters to use. If omitted, the function uses the minimum number of characters necessary.