Converting between Decimal, Hexadecimal, and Binary in Excel
- Sean O'Shea
- Aug 21, 2017
- 1 min read
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.
