Adding Hexadecimal Numbers in Excel

Hexadecimal numbers, also known as hex numbers, are a number system frequently utilized in computing and programming. Unlike the decimal system, which has a base of 10, the hexadecimal system has a base of 16.

In the hexadecimal system,16 digits are represented by the numbers 0-9 and the letters A-F. The first ten digits (0-9) are the same as in the decimal system, while the remaining six digits (A-F) represent values from 10 to 15.

In programming and computer science, hexadecimal numbers are commonly utilized as they offer a concise method of expressing binary data. Each hexadecimal number can correspond to four binary digits or bits, making it simple to convert between the two systems.

How to Add Hexadecimal Numbers in Excel

To add hexadecimal numbers in Excel, you need to convert them to decimal format, perform the addition, and then convert the result back to hexadecimal if necessary.

Let’s consider the following dataset of hexadecimal numbers.

We want to add the hexadecimal numbers using the below steps:

Step #1: Convert the Hexadecimal Numbers to Decimal Format

We use the below steps to convert the hexadecimal numbers in column A to decimal numbers in column B:

  1. Select cell B2 and enter the below formula:
A screenshot of a calculator

Description automatically generated

Note: The HEX2DEC function converts a hexadecimal number to decimal.

  1. Double-click or drag the fill handle in cell B2 to copy the formula down the column.
A screenshot of a spreadsheet

Description automatically generated

Step #2: Add the Decimal Numbers

We add the decimal numbers in column B using the following steps:

  1. Select cell B5 and enter the following formula:
A screenshot of a computer

Description automatically generated

Step #3: Convert the Sum of the Decimal Numbers to Hexadecimal

We use the below steps to convert the sum of the decimal numbers to hexadecimal:

  1. Select cell A5 and enter the below formula:

Note: The DEC2HEX function converts a decimal number to hexadecimal.

The sum of the hexadecimal numbers in cell range A2:A4 is displayed in cell A5 as a hexadecimal number and in cell B5 as a decimal number.


This tutorial showed how to add hexadecimal numbers in Excel. We hope you found the tutorial helpful.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.