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.

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:
Solution examples
I need a formula that has these 2 rules. If letter was rec'd between 1st and 15th = 1st of the month following letter rec'd date. If letter was rec'd between 16thst and end of the month= 1st of the 2nd month following letter rec'd date.
Solved by V. F. in 20 mins
I need a column to total (Hours)(85) + (Travel)(.55) per line
Solved by F. Q. in 20 mins
Trying to figure out what is wrong with my formula in Oct-ZD tab in column AY and BG.
Solved by O. Q. in 8 mins
So I have used vlookup to find the price of a product on a different sheet and then I have tried to times that by a quantity. e.g. =vlookup(d4,table35,2,false)*e4 This is the formula I typed in which worked for another list I did but for some reason it's not working now even though everything is practically the same, apart from the contents. Could you help?
Solved by B. U. in 60 mins
I have a column containing date and time data together and i need to isolate the time data. When I tried to use text to column, it changed all the times to AM. There is an extremely large amount of data - over 550,000 rows so manually changing it won't work. The file is too large to attach.
Solved by S. E. in 40 mins

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