Article updated on March 28, 2018

The BIN2HEX function converts a binary number to hexadecimal.

Formula in cell B3:


Excel Function Syntax



number Required. The binary number you want to convert to hexadecimal.
[places] Optional. The number of characters to use. If not entered the minimum number of characters is used. Use this argument to add leading 0 (zeros).


Maximum binary values are 10 characters.