how to write 1234567890123456789 into a cell with number format

[Anila]

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

 

[Mike H]

Hi,

preceed the input with '

or format as text

Mike

 

[Jim Thomlinson]

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.

 

[James Silverton]

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

Jim Thomlinson

"Anila" wrote:

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