Converting between Decimal, Hexadecimal, and Binary in Excel

Converting between Decimal, Hexadecimal, and Binary in Excel

August 21, 2017

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. 

 

 

Please reload

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com