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

"Bob" wrote:

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
.