Skip to main content
Version: Streamsheets 2.5

HEX2BIN

Converts a hexadecimal number to binary.

Syntax

=HEX2BIN(Number, [Places])

Arguments

NameDescription
NumberThe hexadecimal number to convert.
Places (optional)The number of characters to use for returned value. If value has less characters then it is padded with leading zeros.

Return

The binary number or a #NUM! error if given number is not a valid hexadecimal number. The #VALUE! error is returned if specified places is not numeric or negative.

Examples

FormulaResultComment
=HEX2BIN("F")
1111converts hexadecimal F to binary
=HEX2BIN("F", 6)
001111converts hexadecimal F to binary with 6 characters