BIN2HEX
Converts a binary number to hexadecimal.
Syntax
=BIN2HEX(Number, [Places])
Arguments
Name | Description |
---|---|
Number | The binary number to convert. |
Places | Optional. The number of characters to use for returned value. If value has less characters then it is padded with leading zeros. |
Return Value
The hexadecimal number or a #NUM! error if given number is not a valid binary number. The #VALUE! error is returned if specified places is nonnumeric or negative.
Example
Function | Result | Comment |
---|---|---|
=BIN2HEX(1110) | E | converts binary 1110 to hexadecimal |
=BIN2HEX(1110, 4) | 000E | converts binary 1110 to hexadecimal with 4 characters |