HEX2BIN function
HEX2BIN converts a hexadecimal number to a binary number.
Syntax
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.
Example
=HEX2BIN(64,8) returns 01100100.