Document Solutions for Excel, .NET Edition Overview
Key Features
Getting Started
Features
Templates
Formula Reference
- Add-in and Automation Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
  - BESSELI
  - BESSELJ
  - BESSELK
  - BESSELY
  - BIN2DEC
  - BIN2HEX
  - BIN2OCT
  - BITAND
  - BITLSHIFT
  - BITOR
  - BITRSHIFT
  - BITXOR
  - COMPLEX
  - CONVERT
  - DEC2BIN
  - DEC2HEX
  - DEC2OCT
  - DELTA
  - ERF
  - ERF.PRECISE
  - ERFC
  - ERFC.PRECISE
  - GESTEP
  - HEX2BIN
  - HEX2DEC
  - HEX2OCT
  - IMABS
  - IMAGINARY
  - IMARGUMENT
  - IMCONJUGATE
  - IMCOS
  - IMCOSH
  - IMCOT
  - IMCSC
  - IMCSCH
  - IMDIV
  - IMEXP
  - IMLN
  - IMLOG10
  - IMLOG2
  - IMPOWER
  - IMPRODUCT
  - IMREAL
  - IMSEC
  - IMSECH
  - IMSIN
  - IMSINH
  - IMSQRT
  - IMSUB
  - IMSUM
  - IMTAN
  - OCT2BIN
  - OCT2DEC
  - OCT2HEX
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometry Functions
- Statistical Functions
- Text Functions
- Web Functions
File Operations
Document Solutions Data Viewer
API Reference
Release Notes

HEX2BIN

This function converts a hexadecimal number to a binary number.

Syntax

HEX2BIN(number, [places])

Arguments

This function has these arguments:

Argument	Description
number	[Required] Hexadecimal numeric value to convert, must be between FFFFFFFE00 and 1FF
places	[Optional] Number of characters to return; if not an integer, the number is truncated

Remarks

This function returns an error when the number is not a valid hexadecimal value or if the value for places is non-numeric or negative. If places is omitted, the calculation uses the minimum number of characters necessary. This argument is useful for adding leading zeros to the result.

Examples

HEX2BIN("F",5) gives the result 1