BIN2HEX

Converts a binary number to hexadecimal.

Syntax

=BIN2HEX(Number, [Places])

Arguments

Name	Description
Number	The binary 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 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

Formula	Result	Comment
=BIN2HEX(1110)	E	converts binary 1110 to hexadecimal
=BIN2HEX(1110, 4)	000E	converts binary 1110 to hexadecimal with 4 characters