Hexadecimal Conversions (HEX2DEC & HEX2BIN)
Learn how to convert hexadecimal numbers in Excel with HEX2DEC, HEX2BIN, and HEX2OCT. Decode hardware MAC addresses, memory offsets, and two's complement.
Cybersecurity analysts and system software engineers constantly encounter hexadecimal values in network packet dumps, crash memory offsets, and hardware MAC addresses (like "2A" or "FF").
To compute buffer sizes or parse security permission bits, engineers convert these hex codes into Base-10 decimals or Base-2 binary strings. Excel provides dedicated formulas to perform these base conversions: HEX2DEC, HEX2BIN, and HEX2OCT.
Quick Comparison: Hexadecimal Conversion Formulas
| Formula | Input Base | Target Base | Input Limit | Typical Use Case |
|---|---|---|---|---|
HEX2DEC(number) |
Base-16 (Hex) | Base-10 (Decimal) | 10 hex characters | Converting hardware memory offsets and color bytes into integers. |
HEX2BIN(number, [places]) |
Base-16 (Hex) | Base-2 (Binary) | Max value 1FF (decimal 511) |
Decoding status register flag bits from hex logs. |
HEX2OCT(number, [places]) |
Base-16 (Hex) | Base-8 (Octal) | 10 hex characters | Translating legacy mainframe memory addresses. |
Essential Mechanics and Traps
1. The "0x" Prefix Trap
Unlike programming languages like Python or JavaScript, Excel does not accept the "0x" prefix. Entering =HEX2DEC("0x2A") causes a #NUM! error. Strip the prefix first using the SUBSTITUTE formula: =HEX2DEC(SUBSTITUTE(A2, "0x", "")).
2. The 10-Character Two's Complement Ceiling
Hex strings longer than 10 characters throw a #NUM! error. When the 10th character is between 8 and F, Excel evaluates the string as a negative number in two's complement notation: =HEX2DEC("FFFFFFFFFF") returns -1.
Hands-on Practice Playground
Use the memory offset security log below to convert hexadecimal codes into decimal, binary, and octal formats. Follow each objective to complete the exercise.
In cell C2, convert hex code B2 into its decimal integer using HEX2DEC.
In cell C2, convert hexadecimal code B2 ("2A") into its Base-10 decimal integer using the HEX2DEC formula.
In cell D2, convert the hex code into an 8-bit binary string padded with leading zeros.
In cell D2, convert hexadecimal code B2 into an 8-bit binary string padded with leading zeros using the HEX2BIN formula with places set to 8.
In cell E2, convert the hex code into octal notation using HEX2OCT.
In cell E2, convert hexadecimal code B2 into its octal Base-8 representation using the HEX2OCT formula.
Share This Lesson
Spread the word with your peers and challenge your friends