BIN.TO.HEX
Converts a binary number to hexadecimal.
Syntax
=BIN.TO.HEX(Number, [Places])
Arguments
| Name | Type | Description |
|---|---|---|
| Number | Number | The binary number to convert. |
| Places (optional) | Number | The number of characters to use for returned value. If value has less characters then it is padded with leading zeros. |
Return
| Type | Description |
|---|---|
| Number or Error | 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 not numeric or negative. |
Examples
| Formula | Result | Comment |
|---|---|---|
| E | converts binary 1110 to hexadecimal |
| 000E | converts binary 1110 to hexadecimal with 4 characters |