HEX2BIN Function Explained
The HEX2BIN Function in Microsoft Excel converts a hexadecimal number to a binary number. It takes two arguments: a hexadecimal number and the number of digits in the resulting binary number. The function returns a binary number as a string.
HEX2BIN Function Syntax
HEX2BIN(number, [places])
- number: The hexadecimal number you want to convert.
- places: (optional) The number of characters to use. If omitted, the function uses the minimum number of characters necessary.