Formatting numbers

[SidBord]

I need more info. Where are the numbers originally when
you copy them? I tried copying 9-digit numbers from one
Excel cell to another, and it worked fine. I suspect when
you do the copy, you are taking along some sort of
formatting info that is attached to the target cells when
you paste. You might try using "paste special" and pasting
only the values, which excludes all formatting info in the
copy process. You might also format the target cells as
"general" and see if that helps.

-----Original Message-----
When I copy large numbers and paste them in groups into

excel, it changes the number to scientific notation. If I
go back at that point and change it to text it changes the
last digit in my number to zero which then gives me
inaccurate data. I've tried formatting the page to text
before pasting, but that doesn't help. Does anyone have
suggestions on how I can paste my numbers directly and
accurately into excel?

 

[Dave Peterson]

Maybe you can pick the number using a helper cell:

=mid(a1,23,16)

Mid will treat the value as text--which is good in your case.