Excel like a finance pro.
← The libraryPractice · 2 questions →
Engineering function
HEX2BIN
Converts a hexadecimal number to binary.
Rarely usedDifficulty 1250 · ProficientUsage rank #374 of 520
When to use it
Converts hexadecimal text to binary. The hex value must fit in 10 binary bits (-512 to 511).
The shape of it
- Syntax
=HEX2BIN(number, [places])
Worked examples
Padded
=HEX2BIN("F",8) → 00001111
Padded to eight bits.
One byte
=HEX2BIN("B7") → 10110111
One byte.
Negative
=HEX2BIN("FFFFFFFFFF") → 1111111111
Negative one.
Worth knowing
- Larger hex values need HEX2DEC then BASE(...,2).
- BIN2HEX reverses it.
- Result is text.
Where it goes wrong
- #NUM! for values above 1FF or below FFFFFFFE00.
- Invalid hex digits return #NUM!.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.