Using the Excel HEX2DEC Function
Summary
The Excel HEX2DEC function converts a hexadecimal number to a decimal number.Syntax
=HEX2DEC (number)Syntax Breakdown
NumberRequired. 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