# BIN2HEX

BIN2HEX(number, places)

Returns the number converted from binary to hexadecimal.

 number The binary number you want to convert. places The number of characters to use.

 REMARKS
 * If "number" contains more than 10 characters (10 bits), then #NUM! is returned.* If "number" contains 10 characters then the most significant bit (i.e. the first number) represents the sign bit (i.e. either positive or negative).* If "number" < 0, then two's-complement notation is used to represent the number. (Rows 5 and 6)* If "number" < 0, then "places" is ignored and a 10-character hexadecimal number is returned. (Rows 7 and 8)* If "number" is not a valid binary number, then #NUM! is returned.* If "places" is less than the number of characters needed, then #NUM! is returned.* If "places" is left blank, the minimum number of characters necessary is used. * If "places" is not an integer, it is truncated.* If "places" is not numeric, then #VALUE! is returned.* If "places" < 0, then #NUM! is returned.* The "places" is useful for padding the return value with leading 0s.* You can use the BIN2DEC function to convert a number from binary to decimal.* You can use the BIN2OCT function to convert a number from binary to octal.* You can use the HEX2BIN function to convert a number from hexadecimal to binary.* The equivalent VBA function is VBA.HEX* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

 A 1 =BIN2HEX(1, 1) = 1 2 =BIN2HEX(1, 2) = 01 3 =BIN2HEX(1, 3) = 001 4 =BIN2HEX(10) = 2 5 =BIN2HEX(1110) = E 6 =BIN2HEX(11111011, 6) = 0000FB 7 =BIN2HEX(11111011, 4) = 00FB 8 =BIN2HEX(11111011, 2) = FB 9 =BIN2HEX(11111011, 2.6) = FB 10 =BIN2HEX(111111111) = 1FF 11 =BIN2HEX(1111111111) = FFFFFFFFFF 12 =BIN2HEX(-10) = #NUM! 13 =BIN2HEX(-10, 5) = #NUM! 14 =BIN2HEX(10.75) = #NUM! 15 =BIN2HEX(123456789012) = #NUM! 16 =BIN2HEX("some text") = #NUM!