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

Converts a binary number to hexadecimal.

🌐 Translations

English BIN2HEX
Deutsch BININHEX
Français BINHEX
Español BIN.A.HEX
Italiano BINARIO.HEX
Português BINAHEX
Nederlands BIN.N.HEX
Polski DWÓJK.NA.SZESN
Русский ДВ.В.ШЕСТН

📦 Availability

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

⌨ Syntax

BIN2HEX(number,[places])

Arguments

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

▶ Examples

=BIN2HEX(1110)
=BIN2HEX(11111011,4)
=BIN2HEX(1111111111)

Related functions

Copied to clipboard