Converting between Decimal, Hexadecimal, and Binary in Excel
You can also use formulas in Excel to convert numbers between decimal, hexadecimal, and binary notation. The formulas are easy to remember:
=DEC2HEX - decimal to hexadecimal
=DEC2BIN - decimal to binary
=HEX2DEC - hexadecimal to decimal
=BIN2DEC - binary to decimal
=BIN2HEX - binary to hexadecimal
DEC2BIN won't convert decimal numbers larger than 511.