It actually comes out 100 in my Excel97, but perhaps this will help...

=TEXT(SUM(B1:B12),"0")*1

Vaya con Dios,
Chuck, CABGx3




"osaka78" wrote:

if any one can help

e.g i have $100 in A1 and like to divide it by 12 and round the figure to 3
decimal place and put the result in B1 to M1 and then total of (B1:M1)in N1
the result is $99.996 how can i make it $100 without manually changing the
figures in B1:M1

Regards