Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to Convert Hex Numbers to Decimal Numbers in Excel?
Numbers can be classified into four types: decimal, binary, octal, and hexadecimal. The base values of binary numbers, decimal numbers, octal numbers, and hex numbers are 2, 10, 8, and 16 respectively. We can convert a hex number to a decimal number using formulas in Excel.
A hex number has a base value of 16, and the base values are 0–9 and A–F alphabets. A decimal number has a base of 10, and the base values are 0-9. The base values of an octal number are 0-7. In this tutorial, we will show how you can convert hexadecimal numbers to decimal numbers in Excel and vice versa.
How To Convert Hex Number to Decimal Number
Here we will use the formula to get the first result, then use the auto-fill handle to get all the results. Let us look at a simple procedure for converting a hexadecimal number to a decimal number in Excel using formulas.
Step 1:
Consider an Excel sheet with a list of hexadecimal numbers similar to the image below.
Now click on the empty cell in our case, cell B2, and enter the formula as =HEX2DEC(A2) and click Enter to get our first result, as shown in the below image.
Step 2
Now to get all the results, drag down from the first result using the auto-fill handle, and our final result will be similar to the below image.
We can use the formula =DEC2HEX(A2) to convert any decimal number to a hex number. In the formula, A2 is the address of our values.
Note − In the formula, we can use any combination to convert our values. The first name is our existing number, and the second name is the number we are converting.
BIN – Binary
HEX – Hexadecimal number
Oct – Octal number
DEC – Decimal number
Conclusion
In this tutorial, we used a simple example to demonstrate how you can convert a hexadecimal number to a decimal number in Excel.
3K+ Views
