How to Use HEX2BIN Function in MS Excel 365? – [with Examples]
Tags: excelfunctions, hex2binfunctioninexc
Published: 2020-08-14 11:25:35

---
title: How to Use HEX2BIN Function in MS Excel 365? – [with Examples]
published: true
date: 2020-08-14 06:05:30 UTC
tags: ExcelFunctions,HEX2BINFunctioninExc
canonical_url: https://geekexcel.com/how-to-use-hex2bin-function-in-ms-excel-365-with-examples/
---

## HEX2BIN Function in Excel:

Let’s see the **HEX2BIN Function in Excel 365** with its basic syntax, explanation, and examples. Get official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## Jump To:

- [**HEX2BIN- Function Definition**](#1)
- [**Syntax**](#2)
- [**Examples**](#3)
- [**Wrap-Up**](#4)

## **HEX2BIN – Function Definition:**

- This function will convert the hexadecimal value into a decimal value.
- It is the opposite of[**BIN2HEX Conversion**](https://geekexcel.com/how-to-use-bin2hex-function-in-excel-365-with-example/).

## **Syntax:**

**=HEX2BIN(number, [places])**

**Syntax Definition:**

**Number** – The number (hexadecimal value ) you want to convert into a binary value.

**Places** – It is optional. It is used for padding the output value with leading zeros.

### **Note:**

- If the input is not a valid hexadecimal number, it returns **#NUM!** Error.
- If you give a negative number to places, it returns **#NUM!** Error value.
- If places is a non-numeric value, it will show **#VALUE!** Error.

## **Examples:**

Kindly, see the below examples.

### Example 1:

- You can see the hexadecimal values in column **B** and its corresponding places values in Column **C**.
- Decimal values of column B have been listed in **Column A**.
- The resulted values are placed in column **D**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-23.png)<figcaption id="caption-attachment-11631">Example 1</figcaption>

- As we mentioned before, the “ **places** ” is **an optional value**. If you did not give any values to the places, it will return the exact binary value of the given hexadecimal number.
- For example, without giving any values to the “places” for the hexadecimal **value C** , it will return the **1100** binary value.

### Example 2:

- If the input is not a valid hexadecimal number, it returns **#NUM!** Error.
- If you give a negative number to places, it returns **#NUM!** Error value.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/3-18.png)<figcaption id="caption-attachment-11632">Example 2</figcaption>

### Example 3:

- If places is a non-numeric value, it will show **#VALUE!** Error.

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-20.png)<figcaption id="caption-attachment-11633">Example 3</figcaption>

## **Wrap-Up:**

In this article, you can learn the usage of **HEX2BIN Function in Excel 365** with its syntax, description, and examples. Give your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Functions:

- [**HEX2DEC Function**](https://geekexcel.com/how-to-use-hex2dec-function-in-microsoft-excel-365/)
- [**HEX2OCT Function**](https://geekexcel.com/how-to-use-hex2oct-function-in-microsoft-excel-365/)

### Keep Reading:

- [How to Use BITOR Function in MS Excel 365? – { with Examples }](https://geekexcel.com/how-to-use-bitor-function-in-ms-excel-365-with-examples/)
- [How to Use BIN2DEC Function in Excel 365? (With Examples)](https://geekexcel.com/how-to-use-bin2dec-function-in-excel-365-with-examples/)