Engineering

HEX2BIN Function in Excel

Converts a hexadecimal number to binary.

Syntax

  • =HEX2BIN(number, [places])

Arguments

  • number (required): Hexadecimal number
  • places (optional): Number of characters to use

Examples

  • =HEX2BIN("F", 8) - Hex to binary - Result: 00001111

HEX2BIN in technical sheets

  • Document units in adjacent cells — many engineering functions require exact unit strings.
  • Use [CONVERT](/functions/convert/) for unit changes before specialized formulas.
  • Validate inputs with [ISNUMBER](/functions/isnumber/) and range checks.

Common errors

  • #NUM! if not valid hex

Use cases

  • Number conversion
  • Bit manipulation
  • Programming

Frequently asked questions

  • What is the HEX2BIN function in Excel? HEX2BIN converts a hexadecimal number to binary. The syntax is =HEX2BIN(number, [places]). Typical use cases include number conversion, bit manipulation, programming.
  • How do I use the HEX2BIN function? To use HEX2BIN, type =HEX2BIN( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
  • Why is HEX2BIN not working in my Excel? Common issues with HEX2BIN include #NUM! if not valid hex. Start by checking the syntax =HEX2BIN(number, [places]), then verify each referenced cell or range.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.