Using the Excel DECIMAL Function
SummaryThe Excel DECIMAL function converts the text representation of a number into a decimal number. You can pass the function inputs as binary, octal, hexadecimal and other formats.
Syntax=DECIMAL (number, radix)
The number argument is required in the DECIMAL function. Number is a string of alpha-numeric characters and must be less than or equal to 255 characters. Number is not case sensitive.
The radix argument is also required in the function. The radix is a number that represents the base of the number to be converted. The radix must be an integer in the range of [2,36]. Radix values greater than 10 use numeric values 0-9 and numeric values A-Z, as needed.
Usage NotesThe DECIMAL function returns the decimal equivalent of an alpha-numeric number. The number input must only use valid alpha-numeric characters that corresponds with the correct base.
The DECIMAL function may return the #NUM! or #VALUE! error if either number or radix are outside of the constraints previously mentioned.
It is possible to use the HEX2DEC function and BIN2DEC function to verify the results of DECIMAL.