In Excel you can also format cells to show only a certain number of decimal places. To do this, right-click on the appropriate selection and a context menu will open. Choose? Number format? and then the category ? Number ?, which will allow you to enter the desired number of decimal places. If you enter a 0 in this field, only whole numbers will be displayed. The difference between this process and the ROUND function is that the rounding only affects the format, that is, the presentation : the values are rounded in the table, but behind the scenes? correct numbers are stored, including decimals.
The difference then becomes visible by continuing to trade the numbers . If, for example, the format of the cells has been edited with the values 2,4, 2,3 and 3,3 so that they do not show decimals, only the figures 2, 2 and 3 will be seen. When doing the sum of these values, however, Excel will show 8 as the result, since the program still takes into account the hidden decimals. If the ROUND function had been used, the result would be 7.