Table of Contents
The HEX2DEC function in Excel allows users to easily convert a hexadecimal number to a decimal number. This function takes a hexadecimal value as the input and returns its equivalent decimal value. Simply input the hexadecimal number in the designated cell and use the HEX2DEC function to convert it to its decimal form. This convenient feature saves time and effort in manually converting hexadecimal numbers to decimal in Excel.
This article describes the formula syntax and usage of the HEX2DEC function in Microsoft Excel.
Description
Converts a hexadecimal number to decimal.
Syntax
HEX2DEC(number)
The HEX2DEC function syntax has the following arguments:
Number Required. The hexadecimal number you want to convert. Number cannot contain more than 10 characters (40 bits). The most significant bit of number is the sign bit. The remaining 39 bits are magnitude bits. Negative numbers are represented using two’s-complement notation.
Remark
If number is not a valid hexadecimal number, HEX2DEC returns the #NUM! error value.