Prev: Calculating Turn Around Times excluding Sunday
Next: copy rows to another file
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" <LOGANATHAN IYER(a)discussions.microsoft.com> 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 Sunday
Next: copy rows to another file