View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default CELL IS NOT ACCODATING MORE THAN 12 NUMBRS HOW TO ENTER 15 DIGIT

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