# HEX2BIN

Formulas / HEX2BIN
Convert a hexadecimal number to binary.
`=HEX2BIN(number, [places])`
• number - required, hexadecimal number to convert to binary
• [places] - [OPTIONAL] number of bits in the binary number

## Examples

• `HEX2BIN(A2, 8)`

The HEX2BIN function can be used to convert hexadecimal numbers to binary. The first argument is the hexadecimal number to be converted, while the second argument is an optional number of places the binary number should be padded to.This example will convert the hexadecimal number in cell A2 to binary, and pad the binary number out to 8 places.

• `HEX2BIN(ABCDEFGHIJK, 8)`

HEX2BIN is limited to ten alphanumeric characters. This means it cannot handle hexadecimal numbers with more than ten digits.This example will return an error, as the length of the hexadecimal number is greater than ten characters.

• `HEX2BIN(A2, 16)`

The HEX2BIN function will return a binary number that indicates the magnitude of the hexadecimal number. This example will convert the hexadecimal number in cell A2 to binary, and pad the binary number out to 16 places. The first six bits of the binary number will indicate the magnitude of the hexadecimal number.

## Summary

The HEX2BIN function is used to convert a hexadecimal number to binary. It takes a hexadecimal number as an argument and requires more than the minimum number of characters.

• The HEX2BIN function converts a hexadecimal number to its binary equivalent, returning a binary number.