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.
Updated on: 06-Mar-2023
7K+ Views
- Related Articles
- How to compare two numbers with decimal numbers in Excel?
- How to convert decimal to hex in JavaScript?
- C program to convert roman numbers to decimal numbers
- How to Convert Decimal Number to Binary/Octal/Hex Number or Vice Versa in Excel?
- How to Convert Hex to Binary in Excel?
- How to Generate Random Decimal/Integer Numbers in Excel?
- How To Extract Decimal Numbers From Text String In Excel?
- C++ Program to convert Decimal Numbers to Octal
- Python program to convert hex string to decimal
- How to quickly Convert numbers to English words in Excel?
- Convert the following binary numbers to decimal:10001
- How to Convert Numbers to Words in Indian Rupees in Excel?
- Python program to print decimal octal hex and binary of first n numbers
- How to convert decimal to percentage in Excel?
- How to Align a Column of Numbers by Decimal Point in Excel?
Advertisem*nts
';