HEX2BIN

Converts the specified hexadecimal number to its binary equivalent.

Syntax

HEX2BIN( NumberOrText x, [Number digits] ) → Text

Parameters

x

Required. The hexadecimal number to convert, expressed as either text or number.

digits

Optional. The number of characters to use for the result, useful for padding the return value with leading zeros.

Remarks

If x is not a valid hexadecimal number, the function returns the #VALUE! error value.

If digits is omitted, the function uses the minimum number of characters necessary. If digits is specified and is less than the number of characters required to represent the result, the function returns the #NUM! error value. If digits is negative or greater than 10, the return value is #NUM!. If digits is not an integer number, it is truncated.

Example

Formula

=HEX2BIN(11,8)
=HEX2BIN("10")

See Also

Function Reference
BIN2HEX Function
DEC2HEX Function
OCT2HEX Function