Excel Guides

Converting to Hexadecimal in Excel

To convert a number to hexadecimal in Excel, use the HEX2DEC function. This function converts a hexadecimal number to a decimal number. The function takes two arguments: the hexadecimal number and the base of the number. The base can be any number between 2 and 36, inclusive. For example, to convert the hexadecimal number 3F to decimal, use the following formula:

=HEX2DEC("3F")

The result is 63.

You can also use the DEC2HEX function to convert a decimal number to hexadecimal. This function takes two arguments: the decimal number and the number of digits. For example, to convert the decimal number 63 to hexadecimal with two digits, use the following formula:

=DEC2HEX(63,2)

The result is 3F.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.