You won't have any luck dealing with it as a number as you are limited to 15
significant digits. After that it is rounded... Try this
1. Format the cell as Text
2. Paste the Number
3. When you paste you will get the small clip board in the bottom right of
that paste area. Choose Match Destination Formatting to avoid the implicit
conversion to a number.
--
HTH...

Jim Thomlinson


"Patrick" wrote:

I know for those that use excel all the time this will be a simple question.

I am trying to paste a series of numbers into a spreadsheet the first of
which is
242818203000009150
when I paste it into the cell it shows as
2.42818E+17
and shows the value of the cell to be
242818203000009000

I have formated the cells for text, but ultimately I can't get it display as
the original number or to stop rounding.