The Excel DECIMAL function allows us to convert alpha-numeric representations of numbers in a specified base into their equivalent in decimals.
Figure 1. of Excel Decimal Function
=DECIMAL (number, radix)
- number = alpha-numeric values
- radix – A number value representing the base of the number to be converted (within the range of 2 – 36)
How to Set Decimal Places in Excel
- First, we have to set up the available data in our Excel worksheet:
Figure 2. of Decimal Function in Excel
The input string of numbers (column B above) must contain only valid alpha-numeric characters which correspond with our supplied base (radix).
Below is a standard list of alpha-numeric characters with their correspond base values:
Figure 3. of Standard Alpha-numeric and Base Values in Excel
Our goal in Figure 2. above, is to convert the NUMBER values in column B into the decimal Excel values of the five different bases in column A.
- The Decimal Excel formula we will enter into cell D2 of our worksheet example is as follows:
Figure 4. of Decimal Function in Excel
The number in cell B2 is a binary value that has a base 2. We now know its Excel decimal value is 2 (cell D2).
- To determine the succeeding Excel Decimal values, modify and copy Excel Decimal formula in D2 down into other cells in the column:
Figure 5. of Decimal Function in Excel
Each number is then converted its corresponding Excel decimal value in cells D4to D6.
How to Adjust Decimal Places in Excel
If our goal is to specify or move decimal points in Excel, follow the simple steps below:
- Open the “Format” menu
- Click on the “Format Cells” button, and then a “Format Cells” window will emerge;
Figure 6. of Format Cells Button in Excel
Figure 7. of Format Cells Window in Excel
- Click on the “Number” tab, and then select the “Number” item from the Category list; we should locate the “Decimal Place” button in the right section of the window. From here, we can now format the exact number of decimal places in Excel.
How to Limit Decimal Places in Excel
We can easily limit decimal places in Excel by formatting cells.
Follow the steps below to make Excel limit decimal places
- Select the cell(s) which we want to change their decimal Excel limit and then right click on those selected cells, before selecting the “Format Cells” option which is on the right-click menu;
Figure 8. of Format Cells Button in Excel
- In the next “Format Cells” window, click on the “Number” tab, and then choose “Number” in the Category section, and then enter a number value representing the decimal limit inside the “Decimal Places”input bar..
For example, if we seek to limit the selected cells to just 1 Excel decimal place, simply type “1”
Figure 9. of Decimal Limit in Excel
- Clicking on “OK” will close the Format Cells window and then you will observe all the decimals in our selected cells have been changed to a single Excel decimal place.
Figure 10. of Limit Decimal Places in Excel