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

Converts a hexadecimal number to binary.

🌐 Translations

English HEX2BIN
Deutsch HEXINBIN
Français HEXBIN
Español HEX.A.BIN
Italiano HEX.BINARIO
Português HEXABIN
Nederlands HEX.N.BIN
Polski SZESN.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

HEX2BIN(number,[places])

Arguments

number (required) — The hexadecimal number you want to convert. Number cannot contain more than 10 characters. The most significant bit of number is the sign bit (40th bit from the right). The remaining 9 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, HEX2BIN uses the minimum number of characters necessary. Places is useful for padding the return value with leading 0s (zeros).

▶ Examples

=HEX2BIN("B7")
=HEX2BIN("F",8)
=HEX2BIN("FFFFFFFFFF")

Related functions

Copied to clipboard