HEX2BIN

Description Converts a hexadecimal number (base 16) to a binary number (base 2).

Syntax HEX2BIN ( integer [, places])

Argument Description

integer Any negative or positive whole number or zero. For the purposes of this function, the integer entered must be small enough to convert within the limits of the target. Any integer between FFFFFFFE00 to 1FF may be used.

places Optional number of characters to use in the output. If places is omitted, the function returns the number of spaces required to display the result. The places argument can be used to 0-pad a positive number.If the number is negative, places is ignored and 10 characters are returned.

Argument	Description
integer	Any negative or positive whole number or zero. For the purposes of this function, the integer entered must be small enough to convert within the limits of the target. Any integer between FFFFFFFE00 to 1FF may be used.
places	Optional number of characters to use in the output. If places is omitted, the function returns the number of spaces required to display the result. The places argument can be used to 0-pad a positive number.If the number is negative, places is ignored and 10 characters are returned.

Remarks Note that the result of this function is a text string.

Examples This function returns 10000:

HEX2BIN(10)

This function returns 1111110000:

HEX2BIN("FFFFFFFFF0")

This function returns 000001000:

HEX2BIN(10,10)