# DECIMAL Function in Excel

In this post, you will learn about the Decimal function in Excel and how to use it with-in an excel spreadsheet.

Syntax

`=DECIMAL(number, radix)`

The Decimal Function Syntax has two arguments

number – Holds the alphanumeric values.

radix – A number between the range 2-36 which hold the base/radix for the number to be converted.

Note:

• Both the number and the radix argument is a required factor.
• The word Alphanumeric represents the form that uses or is made up of both numbers and alphabets.

## How does the Decimal Function work in Excel?

When the syntax accepts the values entered, the function takes place and converts the number/character into decimal numbers according to the radix.

• Open a document with the necessary content or enter the numbers to be converted.
• In a new cell enter the syntax and highlight the necessary arguments to include them in the function.
• Press enter to display the answer.
• Use the fill handle to apply the function to the remaining data.

The alphanumeric value you are using in the Decimal function must be a valid character with the given radix.

## Important points:

The following are the most commonly used radix values.

• Only the values between the above-assigned ranges for their respective radix values will be accepted by the syntax.
• The radix argument is a non-case sensitive.
• The function returns #NUM! due to one of the following reasons,
1. The radix value is less than 2 or greater than 36.
2. The value in the number argument is not recognized by the syntax (eg : =,+,<,>,””,….).
3. The number of characters in the number argument is greater than 225.
• And the function returns #VALUE! due to one of the following reasons,
1. The radix argument exceeds the character limit of 225.
2. The radix argument contains a non-numeric value.