Go Back

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

Formula

=HEX2BIN(number,[places])

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.

Example

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

Notes

  • 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.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:

Leave a Comment

avatar