software

I am trying to enter a particular number of 16 digit length (Example:
8312938507652481). This number is being taken as 8312938507652480 in the
excel.

My question is ... is there any limitation in Excel on the number of digits
that can be entered in one cell.

Thanks in advance.

quot;Rayaproluquot; gt; wrote in message
...
gt;I am trying to enter a particular number of 16 digit length (Example:
gt; 8312938507652481). This number is being taken as 8312938507652480 in the
gt; excel.
gt;
gt; My question is ... is there any limitation in Excel on the number of
gt; digits
gt; that can be entered in one cell.

If it's formatted as a number, Excel works only to 15 digit precision. If
you format it as text it will take the number you put in (and if you then
want to treat it as a number you may have to use various tricks to split the
text into parts which are manageable as numbers).
--
David Biddulph
Excel, like nearly all computer software, uses IEEE Double
Precision Floating Point Number, which are limited to 15 digits
of precision. Anything beyond that is rounded. If you don't
intend to do arithmetic on the number, (e.g., it is a phone
number or a credit card number), format the cell as Text prior to
entering the number, or precede the number with an apostrophe.
The apostrophe will not show in the cell but will in the formula
bar.

See www.cpearson.com/excel/rounding.htm for more information.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;Rayaproluquot; gt; wrote in
message
...
gt;I am trying to enter a particular number of 16 digit length
gt;(Example:
gt; 8312938507652481). This number is being taken as
gt; 8312938507652480 in the
gt; excel.
gt;
gt; My question is ... is there any limitation in Excel on the
gt; number of digits
gt; that can be entered in one cell.
gt;
gt; Thanks in advance.
See Help for quot;Specificationsquot; for a list of Excel's limitations. Otherwise,
the previous replies are correct and complete.

Jerry

quot;Rayaproluquot; wrote:

gt; I am trying to enter a particular number of 16 digit length (Example:
gt; 8312938507652481). This number is being taken as 8312938507652480 in the
gt; excel.
gt;
gt; My question is ... is there any limitation in Excel on the number of digits
gt; that can be entered in one cell.
gt;
gt; Thanks in advance.