Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you'll get expert help in seconds

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

How to Use the Excel HEX2BIN Function

While working with excel spreadsheets, you might be required to change a hexadecimal number into a binary. This can be done with the use of the excel HEX2BIN function. This post will provide a clear guide on how to use this function when working with excel spreadsheet.

Figure 1. Final result



How the function works

You first need to note that this function works in a similar way as the LOG10 function, with the only difference being that it converts a hexadecimal number into binary. It is also important to note that this function will return a number into its binary form.

Before one attempts using this function, he should first understand the parameters that guides the use of this function.

  • Number- this can be a hexadecimal number which needs to be converted into binary.
  • Places- this is optional, which serves to pad the numbers with very many zeros.

One should not feel so pressed to use the places, as it is optional and cannot affect how the formula works in anyway.


Figure 2. Example on how to use Excel HEX2BIN Function

Press Enter key to find the binary

Figure 3. Example on how to use Excel HEX2BIN Function

Drag the cursor down to get results for all the other numbers:

Figure 4. Example on how to use Excel HEX2BIN Function


  • Binary numbers only consist of 1s and 0s.  
  • The HEX2BIN function does not work with numbers that have more than 10 digits. As shown in the example, this will result into a #NUM! error value.

Instant Connection to an Expert through our Excelchat Service

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Leave a Comment


Subscribe to

Get updates on helpful Excel topics

Subscribe to
Trusted by people who work at, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc