No. of digits accepted in one cell

[Guest]

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.

 

[David Biddulph]

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.

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

 

[Chip Pearson]

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


message
news:[email protected]...

 

[Guest]

See Help for "Specifications" for a list of Excel's limitations. Otherwise,
the previous replies are correct and complete.

Jerry