Problem with pasting value of a sum

  • Thread starter Thread starter adminservicesJY
  • Start date Start date
A

adminservicesJY

I encountered a problem that's new to me while using autosum on a row of
numbers and blank cells
=SUM(D9:R9)
it seems to produce the correct sum, which is 0.00, but when I copy and
paste special, values, I get a strange number
9.9475983006414E-14

Any ideas?
 
That is a very small number, but in your original cell it will show up
as zero because of the way it is formatted. You could do this to your
formula:

=ROUND(SUM(D9:R9),2)

and then you will get 0.00 when you paste the value elsewhere.

Hope this helps.

Pete
 
Yes, it worked! Thank you.
--
adminservicesJY


Pete_UK said:
That is a very small number, but in your original cell it will show up
as zero because of the way it is formatted. You could do this to your
formula:

=ROUND(SUM(D9:R9),2)

and then you will get 0.00 when you paste the value elsewhere.

Hope this helps.

Pete
Click to expand...
 
Back
Top