Changing Of Column Values ?

[Bob]

Hello,

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 has in:

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 B look correct, I'm satisfied.

The values in column E, with the incredibly large exponent, 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

 

[JLatham]

Make column B wide enough to display 154220000 in it and it probably won't
change to scientific notation format.

 

[Bob]

Hello:

I did.
That's not the problem

Any other thoughts ?

Thanks forhelp,
Bob
------------------------------

 

[JLatham]

It's odd that your source information in column E is the one that is
changing. I actually didn't realize that yesterday.
And no, I'm pretty much out of ideas. The copy shouldn't affect E1 or E2 at
all.

In case someone else comes along to try to figure it out; do E1 and E2 have
formulas in them? Can you look at the formatting for the cells before and
after the copy (and tell us what they are)? I don't know if that info will
help anyone or not, but it might.