Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CELL IS NOT ACCODATING MORE THAN 12 NUMBRS HOW TO ENTER 15 DIGIT
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to enter more than 20 digit numbers in one cell | Excel Discussion (Misc queries) | |||
can't enter a num. in xl cell, which is more than 16 digit or lon | Excel Discussion (Misc queries) | |||
Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) | |||
how can I enter a 21 digit number in a cell & keep it from change | Excel Discussion (Misc queries) | |||
When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) |