logo
excelfunctions.org
bookmarks

HEX2BIN

Converts a hexadecimal number to binary.

EngineeringEngineering & Science

What it does

Converts Hex to Binary.

Syntax

HEX2BIN(number, [places])

Arguments

  • number(text) β€” Hexadecimal number.
  • places(number) β€” Pad length.

Examples

Hex to Bin

Convert F to binary.

FORMULA
=HEX2BIN("F")
RESULT
1111
SAMPLE DATA
A
1Hex
2F