logo
excelfunctions.org
bookmarks

BIN2OCT

Converts a binary number to octal.

EngineeringEngineering & Science

What it does

Converts a binary number (base-2) to an octal number (base-8).

Syntax

BIN2OCT(number, [places])

Arguments

  • number(text) β€” The binary number.
  • places(number) β€” Number of characters to use.

Examples

Binary to Octal

Convert 1001 to Octal.

FORMULA
=BIN2OCT(1001)
RESULT
11
SAMPLE DATA
A
1Binary
21001