Excel HEX2DEC Function

Using the Excel HEX2DEC Function

Excel HEX2DEC Function

Summary

The Excel HEX2DEC function converts a hexadecimal number to a decimal number.

Syntax

=HEX2DEC (number)

Syntax Breakdown

Number
Required. The number, in hexadecimal format, that you wish to convert to decimal. Negative numbers are represented using two's-complement notation. The first bit represents if the number is negative or positive, with the remaining bits indicating the magnitude of the number.

Usage Notes

HEX2DEC converts a number from hexadecimal format to its decimal equivalent.

HEX2DEC Errors
The function will return an error in the following instances:

1) The #NUM! error if number isn't a valid hexadecimal number