Numerical characters in a cell

N

NeilC

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.
 
D

Dave Peterson

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.
 
Top