HEX2BIN function

HEX2BIN converts a hexadecimal number to a binary number.


HEX2BIN(number, [places])

Number is a hexadecimal number. The number can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement.

Places means the number of places to be output.


=HEX2BIN(64,8) returns 01100100.