Thread: Number Problems
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Patrick Patrick is offline
external usenet poster
 
Posts: 160
Default Number Problems

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.