You can also format cells in Excel to display only a certain number of decimal places. By right-clicking on the appropriate position, a context menu will appear in which you can then select “Format cells...”. Under the “Number” tab and the “Number” category, you have the option of specifying the number of decimal places desired. For example, if you enter 0, only integers are displayed. The difference to the ROUND function is that rounding by formatting only affects the presentation. Your spreadsheet shows the rounded number, but the background of the cell contains the correct value including decimal places.
The difference shows up at the latest when you continue to calculate with the numbers: If you have the values 2.4, 2.3, and 3.3 in formatted cells without decimal places, you will only see 2, 2, and 3. But now create the sum of these values, and Excel will show 8 because the program still takes into account the decimal places. If you had worked with the ROUND function instead, the result would be 7.