Converts a binary number to a hexadecimal number.
Syntaxis
BIN2HEX(number, [places])Argumenten
numbervereist
The binary number you want to convert, provided as a string or number.
placesoptioneel
The number of characters to use in the output; useful for padding with leading zeros.
The BIN2HEX function converts a binary string into its hexadecimal equivalent. If the number is negative, the function returns a 10-character hexadecimal number using two's complement notation.
=BIN2HEX("11111011")→FBConverts the binary value 11111011 to its hexadecimal equivalent FB.
=BIN2HEX("101", 4)→0005Converts 101 to hexadecimal and pads the result to 4 characters.
Select the cell
Click on the cell where you want to display the hexadecimal result.
Enter the formula
Type =BIN2HEX( followed by the binary number in quotes and press Enter.
The function can handle binary numbers up to 10 bits (for positive numbers) or 10 characters (for negative numbers).