Converting between Decimal, Hexadecimal, and Binary in Excel
top of page

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.


bottom of page