Instead of rounding that off; click on 'Decrease the decimals' from
'Formatting toolbar' which will change the format...

If this post helps click Yes
---------------
Jacob Skaria


"Fareez" wrote:

A B
7.5 8
8.2 8
9.5 10
3.7 4
7.4 7
7.7 8
Total 44 45
Please refer above example
I have some figures in column "A" it shold be rounded off , done in column
"B" what I want is aftrer rounding off toal increase by 1. that is before
round off total 44 ,after rounding off total 45. is there any way to round
off without affecting total. total sld remain unchanged