Number Precision

R

Rabih

I have a long table that was extracted from oracle
database with two colums of numbers that i need to sum.
the problem i am facing is that whenever i resort the
table i get a different sum (off by two decimal places) i
thaught i had a problem with the sorting/formula location
but this was not the case. it seems the problem lies in
the precisionof the imported numbers.altaugh they have two
decimal precision the totals are coming out with three!!!
and this changes basedon the sorting order.
any solution???
 
J

Jim Rech

altaugh they have two decimal precision the totals are coming out with
Just to confirm that, select the range of imported numbers and change the
format to General (Format, Cells, Number, General). I wouldn't be surprised
if the current number formatting were hiding a few extra digits.
 
Top