HEX.TO.BIN
Converts a hexadecimal number to binary.
Syntax
=HEX.TO.BIN(Number, [Places])
Arguments
Name | Type | Description |
---|---|---|
Number | Number | The hexadecimal number to convert. |
Places (optional) | Number or Error | The number of characters to use for returned value. If value has less characters then it is padded with leading zeros. |
Return
The binary number or a #NUM! error if given number is not a valid hexadecimal number. The #VALUE! error is returned if specified places is not numeric or negative.
Examples
Formula | Result | Comment |
---|---|---|
| 1111 | converts hexadecimal F to binary |
| 001111 | converts hexadecimal F to binary with 6 characters |