Problem with pasting value of a sum
 

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

Problem with pasting value of a sum
 

It's a "common" rounding issue.

To correct it use the ROUND function:

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

--
Biff
Microsoft Excel MVP


"adminservicesJY" wrote in
message ...
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?
--
adminservicesJY

Problem with pasting value of a sum
 

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

On Jan 20, 4:31*pm, adminservicesJY
wrote:
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?
--
adminservicesJY

Problem with pasting value of a sum
 

Yes, it worked! Thank you.
--
adminservicesJY


"T. Valko" wrote:

It's a "common" rounding issue.

To correct it use the ROUND function:

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

--
Biff
Microsoft Excel MVP


"adminservicesJY" wrote in
message ...
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?
--
adminservicesJY

Problem with pasting value of a sum
 

Yes, it worked! Thank you.
--
adminservicesJY


"Pete_UK" wrote:

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

On Jan 20, 4:31 pm, adminservicesJY
wrote:
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?
--
adminservicesJY

Problem with pasting value of a sum
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"adminservicesJY" wrote in
message ...
Yes, it worked! Thank you.
--
adminservicesJY


"T. Valko" wrote:

It's a "common" rounding issue.

To correct it use the ROUND function:

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

--
Biff
Microsoft Excel MVP


"adminservicesJY" wrote in
message ...
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?
--
adminservicesJY

Problem with pasting value of a sum
 

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

Pete

On Jan 20, 6:42*pm, adminservicesJY
wrote:
Yes, it worked! *Thank you.
--
adminservicesJY