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