Converts a hexadecimal number to a binary number.
Sintassi
HEX2BIN(number, [places])Argomenti
numberobbligatorio
The hexadecimal number you want to convert, up to 10 characters long.
placesfacoltativo
The number of characters to use for the output; useful for padding with leading zeros.
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")→1010Converts the hexadecimal value A to binary.
=HEX2BIN("F", 8)→00001111Converts F to binary and pads the result to 8 characters.
Select a cell
Click on the cell where you want to display the binary result.
Enter the formula
Type =HEX2BIN( followed by the hexadecimal value and optional padding length, then press Enter.
The number cannot contain more than 10 characters, and the most significant bit is the sign bit.