To use the BIN2HEX function to convert a binary or decimal to hexadecimal in Excel, ... Method two is to click the Formulas tab and click the More Functions button in the Function Library group.

Let's take the example further, and convert each hexadecimal digit to its decimal equivalent and then add them: (16 2 x 1) + (16 0 x 15) + (16 0 x 4) = (256 + 240 + 4) = 500. Hex and binary in action.

Does anyone know a program that will easily convert between hex and binary (and allow me to cut/copy the results) in Windows 2000? I can't find one.thanks.

Learn about digital data and how computers understand it, including binary, denary, hexadecimal numbers, units of data, character sets and logic gates.