In this article, we will learn about how to use the DECIMAL function in Excel.

To easily us the formula to values, you can simply utilize the keyboard. This is done by simply selecting the cell that you want to replace its formula with value. Then we have to copy the cell by pressing Ctrl + C. The last thing we want to do in order to have the formula replaced by value is to paste it as a value. If you miss it, Excel will mistake your formula as regular text. Space before equal sign: You are not supposed to enter any space before equal sign. Maybe a single space will be hard for us to detect, but it breaks the rule of writing formulas for Excel. Formula wrapped in quotes: You need to make sure that your formula is not wrapped in quotes. In excel, there is no specific function to calculate the ratio. There are four functions to calculate the ratio in excel formula, which can be used as per the requirements. Following are the functions to calculate the ratio in excel formula. Simple Divide Method. SUBSTITUTE and TEXT Function. Using ROUND Function. The user could convert the formulas to text by using the shortcut CTRL+ALT+ V. When the ‘ Paste Special Dialogue Box ‘ opens, the user should select ‘values and number formats’ from the ‘ paste ‘ menu and click OK. The cells will be converted to values as shown in the image. Here are four different ways to convert formulas to their values in Excel. You can download the file here and follow along. If you get a preview, look for.

DECIMAL function in excel is used to convert text representation of numbers of a given base to decimal numbers (base =10).

The table shown below shows you some of the most used base & their radix Alpha - numeric characters

The DECIMAL function converts the number of a given radix to a number of radix 10 (decimal).
Syntax:

Number : value to be converted to decimal.
Radix : or base of the given number. Range from 2 to 36 (integers).
The decimal value is obtained from the number of radix 2 as shown in the above gif.

Converting Formulas To Values Using Excel Formula

Let’s understand this function using it in an example.
The numbers & their Radix or base value. We need to convert these numbers to decimal value which is base 10.

Use the formula:

A2 : number
B2 : radix or base
Values to the DECIMAL function is provided as cell reference.
The decimal representation of 101011 of base 2 is 43 of base 10.

Convert All Formulas To Values In Excel

Now copy the formula to other cells using the Ctrl + D shortcut key.
As you can see here the decimal representation of the numbers from the numbers.
Notes:

1. The argument to the function can be given as text in quotes or cell reference. Numbers can be given as argument to the function directly without quotes or cell reference.
2. The number must be an Alpha numeric number to the given radix or base.
3. The function returns the #NUM! Error
   • If radix is less than 2 or greater than 36.
   • If the argument to the function is not readable by excel.
   • The number characters exceed by 255.
4. The function returns the # VALUE! Error
   • If the text argument exceeds the character limit of 255.
   • If the radix integers is non - numeric.
5. Radix must be an integer greater than or equal to 2 and less than equal to 36.
6. Text argument to the function is not case sensitive.

Hope you understood how to use DECIMAL function and referring cell in Excel. Explore more articles on Excel mathematical conversion functions here. Please feel free to state your query or feedback for the above article.

Popular Articles: