Excel, like most other spreadsheet programs, uses IEEE format for storing
floating point numbers. That format is limited to 15 digits of precision. If
you try to enter a number with 16 digits, the last digit will be lost.

The only way to keep the full 16 digits is to enter the number as text, but
then you can't do arithmetic on it. To increment the final digit, you would
need a VBA macro. That would be fairly simple if you never need to do a
"carry", but quite complicated if the number is, say 2059519999999999.



On Tue, 8 Mar 2005 18:11:01 -0800, "Croc001"
wrote:

Using excel 2000
recieving data from client with 16 numeral characters within cells
cells show an abreviated listing for the number (2.06E+15)
When editing the the number (wanting to change the last number by 1 digit)
i.e.
2059510000000000 - change to - 2059510000000001
this change will not be kept??

I format the cell to "numbers" with no decimal point as a whole number is
required

Any ideas??
Is this number to long for excell 2000??

I'm not a big excel user

Cheers
Croc001