# 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.

What is HEX2BIN?
HEX2BIN is a function in programming that converts a hexadecimal number to binary digits.
How many characters does the binary number use?
The binary number is created by using 10 characters.
What is required to use the HEX2BIN function?
HEX2BIN requires a hexadecimal number as an argument.
Is the places argument required?
The places argument is optional.

## Make Better Decisions With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.

Drop CSV