How to convert hex to binary in Excel?

Hex numbers and binary numbers are usually used in computer technology, but do you know how to convert hex numbers to binary numbers and vice versa? Now I will tell you the easy way to solve the conversion between hex and binary in Excel worksheet.

Convert hex to binary

Convert binary to hex

Convert hex to binary

There is a formula can convert the hex number to binary number.

Select a blank cell adjacent to the hex number cell, and type this formula =HEX2BIN(A2) (A2 stands for the cell you want to convert) into it, and press Enter key to apply this formula, and if you need, you can drag its AutoFill handle to a range. See screenshot:

Convert binary to hex

In reverse, if you want to convert binary number to hex number, you can use below formula.

Select a blank cell adjacent to the hex number cell, and type this formula =BIN2HEX(A2) (A2 stands for the cell you want to convert) into it, and press Enter key to apply this formula, and if you need, you can drag its AutoFill handle to a range. See screenshot:

Relative Articles:

• Convert hex to decimal