Home › Functions › Engineering › OCT2BIN
fx
OCT2BIN
Engineering  ·  Since: Excel 2003  ·  9 languages

Converts an octal number to binary.

🌐 Translations

English OCT2BIN
Deutsch OKTINBIN
Français OCTBIN
Español OCT.A.BIN
Italiano OCT.BINARIO
Português OCTABIN
Nederlands OCT.N.BIN
Polski ÓSM.NA.DWÓJK
Русский ВОСЬМ.В.ДВ

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

OCT2BIN(number,[places])

Arguments

number (required) — The octal number you want to convert. Number may not contain more than 10 characters. The most significant bit of number is the sign bit. The remaining 29 bits are magnitude bits. Negative numbers are represented using two's-complement notation.
places (optional) — The number of characters to use. If places is omitted, OCT2BIN uses the minimum number of characters necessary. Places is useful for padding the return value with leading 0s (zeros).

▶ Examples

=OCT2BIN(3,3)
=OCT2BIN(7777777000)

Related functions

Copied to clipboard