BIN2HEX

BIN2HEX —

BIN2HEX(number[,places])

BIN2HEX function converts a binary number to a hexadecimal 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.

BIN2HEX(100111) equals 27.

HEX2BIN, BIN2OCT, BIN2DEC.