Converts a hexadecimal number to a decimal number.
Söz dizimi
HEX2DEC(number)Bağımsız değişkenler
numberzorunlu
The hexadecimal number you want to convert.
The HEX2DEC function takes a hexadecimal string and converts it into its equivalent decimal integer. The number argument cannot contain more than 10 characters, and the most significant bit is the sign bit, representing negative numbers using two's complement notation.
=HEX2DEC("A5")→165Converts the hexadecimal value A5 to its decimal equivalent 165.
=HEX2DEC("FFFFFFFFFF")→-1Converts the 10-character hexadecimal string representing -1 in two's complement.
Select a cell
Click on the cell where you want to display the decimal result.
Enter the formula
Type =HEX2DEC("hex_value") replacing hex_value with your hexadecimal string.
Press Enter
Press the Enter key to calculate and view the decimal conversion.
The function supports hexadecimal numbers up to 10 characters long, ranging from FFE0000000 to 1FFFFFFFFF.
This error occurs if the input number is invalid, exceeds the 10-character limit, or is outside the supported range.