how to write 1234567890123456789 into a cell with number format

A

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
 
J

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.
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top