Excel Formula Calculation Error in adding

[longer]

I entered a formula of sum=(E11:E56) for example and excel did not return a
correct calculation. I checked the format of the cells and it is a custom
one. I checked for hidden values and could not find any (to my understanding
it will show a blank cell but if the cell is highlighted and it is a hidden
value it will show the number in the formula bar). The sum that Excel
returned is exactly 6033 over, which is a value that is included of what I
told excel to add for me. Any ideas? I changed the format to general, to a
number, etc and it did not help. THank you.

 

[Edward O'Brien]

I have heard this one before, but can't rmember the answer. (Excel does not
always give the correct calc owing to the way it works)

I think you stand a better chance of solving this one at:
microsoft.public.excel.misc

Ed