Type the formula into the cell you want to place the result =FIXED(A2,1). Then press the Enter key to see the result. You will notice that Excel will round the number one digit to the right of the ...

If Excel is not highlighting cells in the formula, read this post to ... users who’s facing the same problem, keep reading further to know how to fix the issue. Enable ‘Allow editing directly ...