From: LOGANATHAN IYER LOGANATHAN on 19 May 2010 02:55 I AM NOT ABLE TO ENTER MORE THAN 12 DIGITS I .E. 123456789012 THE CELL DOES NOT ACCOMMODATE - AFTER ENTERING: 123456789012345678 THE RESULT SHOWN IN CELL IS : 1234567E+15 HOW TO SOLVE THIS PRIOBLEM From: Jacob Skaria on 19 May 2010 03:01 Excel follows the IEEE 754 specification on how to store and calculate floating-point numbers. Excel therefore stores only 15 significant digits in a number, and changes digits after the fifteenth place to zeroes. To work around this behavior, format the cell as text. The cell can then display up to 1,024 characters. or prefix your entry with an apostrophe ' -- Jacob (MVP - Excel) "LOGANATHAN IYER" wrote: > I AM NOT ABLE TO ENTER MORE THAN 12 DIGITS I .E. 123456789012 > THE CELL DOES NOT ACCOMMODATE - AFTER ENTERING: 123456789012345678 > THE RESULT SHOWN IN CELL IS : 1234567E+15 > HOW TO SOLVE THIS PRIOBLEM From: "David Biddulph" groups [at] on 19 May 2010 03:26 Please stop SHOUTING. If you've entered 123456789012345 and want to see it that way, format as a number with zero decimal places. The machine works to only 15 significant figures so 1234567890123456 would appear as 1234567890123450; if you want to see all the digits, you'll need to pre-format the cell as text, or to precede the "number" with an apostrophe to turn it into text. -- David Biddulph "LOGANATHAN IYER" wrote in message news:1047CC08-E7EF-432B-B4B9-50D7A95C1E0B(a)microsoft.com...> I AM NOT ABLE TO ENTER MORE THAN 12 DIGITS I .E. 123456789012 > THE CELL DOES NOT ACCOMMODATE - AFTER ENTERING: 123456789012345678 > THE RESULT SHOWN IN CELL IS : 1234567E+15 > HOW TO SOLVE THIS PRIOBLEM  |  Pages: 1 Prev: Calculating Turn Around Times excluding SundayNext: copy rows to another file