numbers

Let's say you have 1.234 in cell B2.

To get 1 you could use =ROUND(B2,0)

To get 1.2 you would use =ROUND(B2,1)

To get 1.23 you would use =ROUND(B2,2)

In certain situations you could also use INT or TRUNC.

Explanations of all these functions, with examples, can be found via your menu at Help > Formulas and Functions Help.

Substitute ; for , in the formulas if your regions uses , as a decimal separator.

Note that these functions actually change the value in the cell. If you want to keep the original value in the cell but only display a rounded figure, then you can select the cells and use Data Format in the inspector panel at the right.

SG

Strongly recommend you use the last option SG suggested, and only change the display, not the values themselves. If you round all values to the nearest integer and then perform calculations on them, you’ll get inaccurate results.

A further note to avoid confusion. Which approach one uses (rounding via function or just rounding the display) depends very much on what one is trying to do. For example if one is working with currency amounts to two decimal places where one wants figures to "add up" without annoying rounding differences then one of the rounding functions is the way to go. Those functions exist for a reason, after all, and have many valid uses.

There are many situations where the extra internal precision in Numbers is not desirable. More precision does not necessarily need mean more accuracy. Less precision does not necessarily mean less accuracy. False precision can be a problem.

A key point to keep in mind is that just because a number is formatted to display in a certain way in Numbers does not mean that the value in the cell is the same as what appears in the cell. There may be "hidden" precision in there that give you results you weren't expecting.

SG