The operations and functions that are performed in Microsoft Excel are very varied and the results they produce are typical of any calculation system. Being so precise, implies that in a cell we find numbers with large decimal extensions. This shouldn’t be a problem if we’re just looking for that number.
However, when making, for example, templates with budgets we do not need such exact data, this precision can be a problem. And is that cells show a number of bounded digits determined by their dimension.
To solve this difficulty is that rounding and other functions are used. If you want to learn more about it, continue with this post.
What should we keep in mind when rounding decimals in our spreadsheet?
The first thing you should know is that this tool is recommended only when rejecting decimal places does not imply a problem. That is, If you need results with maximum accuracy, we do not recommend this function.. You always can resize cells and in this way prevent the pads from appearing “######”.
The second thing is that the function ROUND OUT from Excel, abides by the standard rule. This means that if the last digit is greater than or equal to five, raises by 1 the value of the penultimate. And if it is less, the previous number is kept unchanged.
You must bear in mind that the following operations that are performed using the cells with rounded figures, will take as value the modified number and not the original. Although it seems a minor detail, it may imply a change in the result as you can see in the image.
Steps to add decimals to a group of data in an Excel spreadsheet
There are several methods to define the number of visible decimal places in a cell or group of cells in an Excel document. In Internet Step by Step We will show you how to do each of them. Take note.
This function, as we mentioned before, shorten the number of digits of a number after the comma (or period, depending on the region). And he does it by taking the last of them. Microsoft Excel offers two ways to do this. Both are very simple and applicable to any cell. The first one requires us to enter a formula in the corresponding bar.
To do this, do the following:
- Create a new spreadsheet document or open an existing one.
- Write the values of the numbers you want to round in separate cells. If you do it in the same column it will be simpler and more orderly.
- In the second column put the formula “= ROUND (A1; N)” Replace the letter N with the number of digits you want to display. In the example we use “= ROUND (A1; 1)”
- To do the same with the following figures, you don’t need to write everything again. Alone drag this last cell from its lower right corner to the bottom. You can also copy and paste it, as long as it is in the same column.
The second method for rounding is on the ribbon. It requires significantly fewer steps than the previous one, since it does not use formulas:
- In the same way as before, put the values you want to reduce in a column.
- Choose one or all they.
- Go to the tab “Start”. In the section “Alignment” you will find two buttons with opposite arrows followed by zeros (see image).
- Each one of these, reduce or increase by one digit the number of the selected cell.
Tip: No rounding
As you have noticed all the above methods are based on the general rule of approximation, which raises the figure or not depending on whether the next one is higher or lower than 5. However, there is a function that ignores this.
What it does is simply hide leftover digits without taking rounding into account symmetrical. Which means that does not eliminate what we consider remnants. That is why other operations can be performed that will take the entire figure, including the hidden digits.
To use this feature, just follow these steps:
- In an empty cell put the formula “= TRUNCATE (A1; N)” where A1 is the box where the number with decimals is found and the letter N is the number of digits that we want to display.
- Press “Enter” to end.
If you have any questions, leave them in the comments, we will answer you as soon as possible, and it will surely be of great help to more members of the community. Thank you! 😉