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

Hi,

preceed the input with '

or format as text

Mike

"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. The only easy way around it is to
store the number as text as Mike H indicates. Doing that however means that
you can not perform any math functions against the number.
--
HTH...

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

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