HEX2BIN

HEX2BIN —

HEX2BIN(number[,places])

HEX2BIN function converts a hexadecimal number to a binary number. places is an optional field, specifying to zero pad to that number of spaces.

If places is too small or negative #NUM! error is returned.
This function is Excel compatible.

HEX2BIN("2A") equals 101010.

BIN2HEX, HEX2OCT, HEX2DEC.