Changing Of Values After A Copy And Paste Special: Why ?

[Bob]

Hello,

I tried the new user Excel Forum, but no luck.
Would like to try here, as this really has me baffled, and a bit concerned.

Using Excel 2007 and Windows7

This sure seems "funny," and was hoping someone might explain it for me:

In B1 I have the value 154.22
In B2 I have the value 33.74

In E1 I have 154000000
In E2 I have 33740000

I copy from Column E, and do a Paste Special in Column B

Column B looks correct, as it now has in it:

B1 the value 154220000
B2 the value 33740000

But-

E1 has changed to 1.5422E+14
E2 has changed to 3.374E+13

In the Paste Special dialog box that came up I selected for Paste:
Values, and Operation: None

As the values in Column B look correct, I'm satisfied, I think.

The values in column E, with the incredibly large exponents, e.g., the
E+14, were meant to be deleted after the Copy and Paste Special anyway.

But why have they (column E)changed to such a large value ?
I find this very disturbing, and would like to understand what happened.

Thanks,
Bob

 

[David Biddulph]

You didn't what is in E1 and E2. Perhaps they have formulae like
=B1*1000000 ? In which case, their new values are correct, given the new
values which you have pasted into B1 and B2.

I assume that when you told us "In E1 I have 154000000" you perhaps meant to
say "In E1 I have 154220000" ?