excel change the last 16th digit into 0 -excel 2007
- Thread starter Asher
- Start date
bobhc
Excel Ninja
Good day Asher and welcome the forum if you have not already done so, please read this link as it will help in the use of the forum.
http://chandoo.org/forum/forums/new-users-please-start-here.14/
This is a "bug" in Excel 2007 (and all other Excel releases.)that it converts all the digits after 15th digit into 0s (zeroes).
...the amount of precision possible may vary depending on the size of the number (the mantissa) being manipulated. In the case of Excel, although Excel can store numbers from 1.79769313486232E308 to 2.2250738585072E-308, it can only do so within 15 digits of precision. This limitation is a direct result of strictly following the IEEE 754 specification and is not a limitation of Excel. This level of precision is found in other spreadsheet programs as well.
This will help you
http://support.microsoft.com/kb/78113
.
.
http://chandoo.org/forum/forums/new-users-please-start-here.14/
This is a "bug" in Excel 2007 (and all other Excel releases.)that it converts all the digits after 15th digit into 0s (zeroes).
...the amount of precision possible may vary depending on the size of the number (the mantissa) being manipulated. In the case of Excel, although Excel can store numbers from 1.79769313486232E308 to 2.2250738585072E-308, it can only do so within 15 digits of precision. This limitation is a direct result of strictly following the IEEE 754 specification and is not a limitation of Excel. This level of precision is found in other spreadsheet programs as well.
This will help you
http://support.microsoft.com/kb/78113
.
.
Last edited: