Originally Posted by Spencer101

Use round on single cells rather that the range.
So, =ROUND(A2,0) and drag/copy across.

If these cells show as having a decimal place but all of those are zero, then it's formatting rather than the formula not working.

Also worth considering ROUNDDOWN / ROUNDUP depending on how ou need the results. 17.9 for example wold become 18 with ROUND or ROUNDUP, but 17 with ROUNDDOWN.