Converts a hexadecimal number to a binary number.
Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.
HEX2BIN(number, [places])The HEX2BIN function converts a hexadecimal string into its binary equivalent. If the number is negative, the function returns a 10-character two's complement binary number.
=HEX2BIN("A")Ergebnis: 1010
Converts the hexadecimal value A to binary.
=HEX2BIN("F", 8)Ergebnis: 00001111
Converts F to binary and pads the result to 8 characters.
The number cannot contain more than 10 characters, and the most significant bit is the sign bit.