Navigation:  Formula Reference > Spreadsheet Formula Functions >

HEX2BIN

Previous pageReturn to chapter overviewNext page

 

This function converts a hexadecimal number to a binary number.

Syntax

HEX2BIN(number, places)

Arguments

This function has these arguments:

Argument

Description

number

Hexadecimal numeric value to convert, must be between FFFFFFFE00 and 1FF

places

[Optional] Number of characters to return; if not an integer, the number is truncated

Remarks

This functions returns an error when the number is not a valid hexadecimal value or if the value for places is non-numeric or negative. If places is omitted, the calculation uses the minimum number of characters necessary. This argument is useful for adding leading zeros to the result.

Data Types

Accepts numeric data. Returns numeric data.

Examples

HEX2BIN("F",5)

 

See Also

BIN2HEX

HEX2DEC

HEX2OCT

OCT2HEX