Go Back

Excel DECIMAL function

Just as it is with using other different functions in Excel, there are also ways to use the DEVSQ function. This post will guide you on how to use the Excel DECIMAL function in Excel with syntax.

Syntax 

=DECIMAL (number, radix)

Where:

  • number – A string of alphanumeric characters you want to convert.
  • radix –  An integer within the range [2, 36] corresponding with the provided base.

Example

Figure 1: Excel DECIMAL function

Explanation

The Excel DECIMAL function receives an alpha-numeric integer/number in a specific base and returns its corresponding decimal value.

Listed below are some Base values and their corresponding alpha-numeric characters

Common Errors

  1.#NUM! – Occurs if:

  • The provided radix is less than 2 or greater than 36;
  • The provided text argument is unrecognized as a number in the specific radix.

  2. #VALUE! – Occurs if:

  • The provided text argument is above 255 characters long;
  • The provided base is non-numeric

USEFUL NOTES

  • The input string must contain only valid alpha-numeric characters that correspond to the base of the integer to be converted.
  • The Decimal function is not available in the earlier versions of Excel before 2013.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

long decimal numbers to round up to just 2 places after the decimal. for the entire row
Solved by G. H. in 11 mins
I am trying to insert a decimal point in excel 2016, it is not saving when I check the decimal point box.
Solved by S. L. in 23 mins
CHange decimal number into hour................
Solved by C. C. in 15 mins

Leave a Comment

avatar