Jim wrote on Fri, 13 Feb 2009 06:53:01 -0800:

Jim Thomlinson

"Anila" wrote:

I want to enter more than 16 digits into a cell in number
format (the number should not converted to exponential
format). The digits from 16th digit are being converted to
zeros. How to avoid it

What you are describing is a limitation of your computer more than a
limitaion of XL. Your computer only tracks 15 significant digits in a
number.
Anything after that it truncates to zero.

It would not be impossible for a version of Excel to circumvent word
length but its use would be infrequent and probably slow, IMHO. I wonder
is there a spread sheet program for 64-bit computers that allows greater
precision?

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not