DECIMAL

Using the Excel DECIMAL Function

Summary

The 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)

Syntax Breakdown

number
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.

radix
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 Notes

The 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.

Excel DECIMAL Bases

DECIMAL Errors
The DECIMAL function may return the #NUM! or #VALUE! error if either number or radix are outside of the constraints previously mentioned.

Verifying Results
It is possible to use the HEX2DEC function and BIN2DEC function to verify the results of DECIMAL.

Excel DECIMAL Verification Example