HEX2BIN

HEX2BIN binary representation of the hexadecimal number x

Synopsis

HEX2BIN(x,places)

Arguments

x: a hexadecimal number, either as a string or as a number if no A to F are needed

places: number of digits

Description

If places is given, HEX2BIN pads the result with zeros to achieve exactly places digits. If this is not possible, HEX2BIN returns #NUM!

Microsoft Excel Compatibility

This function is Excel compatible.

See also

BIN2HEX, HEX2OCT, HEX2DEC.