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