CELL IS NOT ACCODATING MORE THAN 12 NUMBRS HOW TO ENTER 15 DIGIT

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

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

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 wrote in
message ...
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