Problem with pasting value of a sum

[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?

 

[Pete_UK]

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

 

[adminservicesJY]

Yes, it worked! Thank you.
--
adminservicesJY

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

 

[Pete_UK]

You're welcome - glad to hear it worked for you.

Pete