View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Excel only keeps track of 15 digits.

If you can treat the digits as text, you can prefix your entry with an
apostrophe:

'123451234512345

or preformat the cell as Text first (format|Cells|Number tab)
Then type in your entry.

NeilC wrote:

I am using Execll 2002 and cannot put more than 15 numbers in a cell before
it shortens the numbers. Is there a way of changing how many numerical
characters in a cell.
--
Neil


--

Dave Peterson