Wow! Didn't expect such great responses so quickly. In the case of the
formatting, the formula is formatted as a number with 6 decimal places (it
has to be). What if part of the formula has a hard number (like 100) and not
a cell reference? Would that be apart of the problem?

"Dave Peterson" wrote:

And if your cell with the =sum() formula is formatted as general, maybe you're
only seeing 2 decimal places.

Try widening that column or change to a smaller font.

Janet wrote:

I am using SUM to add up a column with numbers that have six decimals. I do
not want the answer to be rounded up. How can I create a formula not to round
the answer, using SUM? Thanks

--

Dave Peterson