Skip to main content
Version: Streamsheets 3.0

BIN.TO.HEX

Converts a binary number to hexadecimal.

Syntax

=BIN.TO.HEX(Number, [Places])

Arguments

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

Return

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

Examples

FormulaResultComment
=BIN.TO.HEX(1110)
Econverts binary 1110 to hexadecimal
=BIN.TO.HEX(1110, 4)
000Econverts binary 1110 to hexadecimal with 4 characters