The Excel DECIMAL Function

Related Function:
Base Function

Basic 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:


The text representation of the number that you want to convert

(must be less than 256 characters long).

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:

1=DECIMAL( "1100", 2 )
2=DECIMAL( "186A0", 16 )
3=DECIMAL( "31L0", 32 )
4=DECIMAL( "70122", 8 )
5=DECIMAL( "2000", 2 )

Note that, in the above spreadsheet:

Further details and examples of the Excel Decimal function are provided on 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

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

Occurs if either:

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