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.
"Bob" wrote:
> Hello:
>
> I did.
> That's not the problem
>
> Any other thoughts ?
>
> Thanks forhelp,
> Bob
> ------------------------------
>
> On 3/15/2010 2:22 PM, JLatham wrote:
> > 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
> >> .
> >>
>
> .
>
|
Similar Threads
