format the cell as text, but paste the value into the formula bar.

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.

--

Dave Peterson