Engineering

BIN2OCT Function in Excel

Converts a binary number to octal.

Syntax

  • =BIN2OCT(number, [places])

Arguments

  • number (required): Binary number
  • places (optional): Number of characters to use

Examples

  • =BIN2OCT(1001, 3) - Binary to octal - Result: 011

BIN2OCT in technical sheets

  • Document units in adjacent cells — many engineering functions require exact unit strings.
  • Use [CONVERT](/functions/convert/) for unit changes before specialized formulas.
  • Validate inputs with [ISNUMBER](/functions/isnumber/) and range checks.

Common errors

  • #NUM! if not valid binary

Use cases

  • Number conversion
  • Unix permissions
  • Programming

Frequently asked questions

  • What is the BIN2OCT function in Excel? BIN2OCT converts a binary number to octal. The syntax is =BIN2OCT(number, [places]). Typical use cases include number conversion, unix permissions, programming.
  • How do I use the BIN2OCT function? To use BIN2OCT, type =BIN2OCT( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
  • Why is BIN2OCT not working in my Excel? Common issues with BIN2OCT include #NUM! if not valid binary. Start by checking the syntax =BIN2OCT(number, [places]), then verify each referenced cell or range.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.