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.