Why the number 12,345,678,987,654,321 is not displaying in Excel
Excel in common with other software has only 15 digits of precision, anything
above that is truncated. If you want to display larger numbers but not do
calculations on them precede the entry with an apostrophe.
Mike
"Muhammad Zafeer" wrote:
When I take the square of # 111,111,111, It must be 12,345,678,987,654,321.
But MS Excel is showing as 12,345,678,987,654,300.
There is a difference of 21.
Please Explain
|