Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
All articles CONDITIONAL FORMATTING Excel DECIMAL function

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:

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

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

Another blog reader asked this question today on Excelchat:

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc