How to Use BIN2HEX Function in Excel 365? {With example}
Tags: bin2hexfunctionsinex, excelfunctions
Published: 2020-08-11 06:05:27

---
title: How to Use BIN2HEX Function in Excel 365? {With example}
published: true
date: 2020-08-10 11:42:26 UTC
tags: BIN2HEXFunctionsinEx,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-bin2hex-function-in-excel-365-with-example/
---

## BIN2HEX Function in Excel:

In this article, we are going to learn how to use **BIN2HEX Function** in Excel 365. This function will convert the binary values to hexadecimal values. Let’s see the Definition, syntax, and examples of BIN2HEX function.


## BIN2HEX – Function Description:

- This function is used to **convert binary numbers to hexadecimal numbers** in Excel 365.
- If the binary number has more than 10 characters, it will return **#NUM!** Error value.
- If you give the negative number, this function ignores places and returns the 10 character hexadecimal numbers.

## Basic Syntax:

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

### Argument Description:

**Number** – The binary number that you want to convert into hexadecimal numbers.

**Places** – It is optional. If places are not given, then it will return the exact hexadecimal value to the input number. It is mainly used for padding the return values with leading zeros.

### Note:

- If places is not an integer, it will return **#VALUE!** Error.
- If you give any non-numeric numbers in the places argument, it will return **#VALUE!** Error.
- In case, if you give a negative value to places, it will return **#NUM!** Error value.

## Examples:

Let’s see some examples for binary to hexadecimal conversion.

- Refer to the below example.

![Binary to Hexadecimal Conversion](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-13.png)<figcaption id="caption-attachment-11504">Binary to Hexadecimal Conversion</figcaption>

- If you give a negative value to places, it will return **#NUM!** Error value. See the following screenshot.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-11.png)

- If you give any non-numeric numbers in the places argument, it will return **#VALUE!** Error.
- Non-numeric values include special characters, alphabets will return **#VALUE!** Error.
- Refer to the below example.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/3-10.png)

## Video Tutorial:

<iframe src="https://www.youtube.com/embed/t3BvZIyccF4" width="560" height="315" frameborder="0" allowfullscreen="allowfullscreen"></iframe>

## Closure:

In the above article, you can understand the usage of **BIN2HEX Function** in **Excel** 365 with the examples. Kindly, drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Keep Reading:

- [How to Use PHONETIC Function in Microsoft Excel 365?](https://geekexcel.com/how-to-use-phonetic-function-in-microsoft-excel-365/)
- [ISNONTEXT Function in Microsoft Excel 365- How to use ?](https://geekexcel.com/isnontext-function-in-microsoft-excel-365-how-to-use/)
- [Use Excel TEXTJOIN Function – Definition with Examples!!](https://geekexcel.com/excel-textjoin-function-definition-with-examples/)