The Excel DECIMAL Function

Related Function:
Base Function

Function Description

The Excel Decimal function converts a text representation of a number in a specified base, into a decimal value.

Note: the Decimal function was only introduced in Excel 2013 and so is not available in earlier versions of Excel.

The syntax of the function is:

DECIMAL( text, radix )

Where the arguments are as follows:

text-

The text representation of the number that you want to convert

(must be less than 256 characters long).
radix-

The base (radix) of the supplied number

(must be an integer ≥ 2 and ≤ 36).


Excel Decimal Function Examples

The following spreadsheet shows four examples of the Excel Decimal Function:

 Formulas:
 A
1=DECIMAL( "1100", 2 )
2=DECIMAL( "186A0", 16 )
3=DECIMAL( "31L0", 32 )
4=DECIMAL( "70122", 8 )
5=DECIMAL( "2000", 2 )
 Results:
 A
112
2100000
3100000
428754
5#NUM!

Note that, in the above spreadsheet:


For further details and examples of the Excel Decimal function, see the Microsoft Office website.


Decimal Function Errors

If you get an error from the Excel Decimal function, this is likely to be one of the following:

Common Errors
#NUM!-

Occurs if either:

  • The supplied radix is < 2 or > 36;
  • The supplied text argument is not recognised as a number in the specified base (radix).
#VALUE!-

Occurs if either:

  • The supplied text argument is greater than 255 characters long;
  • The supplied radix is non-numeric.