HEX2BIN Function in Excel – Convert Hexadecimal to Binary in Excel

HEX2BIN Function in Excel converts Hexadecimal number to Binary number.

Syntax of HEX2BIN Function in Excel (HEXADECIMAL TO BINARY FUNCTION IN EXCEL):

HEX2BIN(number,[places])

Where

number – The Hexadecimal number that is to be converted to Binary.
[places] – An optional argument that specifies how many digits needs to be returned.

Example of HEX2BIN Function in Excel (HEXADECIMAL TO BINARY FUNCTION IN EXCEL):

Formula:

HEX2BIN Function in Excel 1

In row number 1, HEX2BIN Function takes up [places] argument as 8 which returns the 8 digits with 4 preceding Zeros i.e. 00001010.

Result:

HEX2BIN Function in Excel 2

Note: #NUM! – Error occurs

If the supplied number contains more than 10 character.
If the resulting binary number exceeds more than 10 digits.
If the supplied [places] argument is less than 0 and greater than 10.