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
|