PDA

View Full Version : Input more than 15 digits numbers in a cell in a worksheet



rangudu_2008
09-29-2009, 07:12 PM
Hi all,
Is there a way to Input more than 15 digit numbers in a worksheet. Excel automatically rounds-off if its more than 15 digits.

Ranga

GTO
09-29-2009, 08:30 PM
Hi Ranga,

I could be wrong, but I don't believe Excel actually rounds past the 15th digit, but truncates. I'm pretty sure you're not getting past the 15 digit limitation. You might find these interesting:

http://support.microsoft.com/kb/78113

http://support.microsoft.com/kb/158071

http://blogs.msdn.com/excel/archive/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers.aspx

Mark

Paul_Hossler
09-30-2009, 05:23 PM
Hi all,
Is there a way to Input more than 15 digit numbers in a worksheet. Excel automatically rounds-off if its more than 15 digits.


If you're looking for more that 15 digits of computational precision, there is an add in you can look at

http://digilander.libero.it/foxes/MultiPrecision.htm


From the intro page



Xnumbers is an Excel addin that performs multi-precision floating point arithmetic from 1 up to 250 significant digits. It consists of a set of more than 220 functions for arithmetic, trigonometric, logarithmic, exponential and matrix calculus.

The basic arithmetical functions: addition, multiplication, and division were developed first. They form the basic kernel for all other functions.

All functions perform multiprecision floating point computations for up to 250 significant digits. You can set a precision level separately for each function by an optional parameter. By default, all functions use the precision of 30 digits, but the numerical precision can easily be regulated continually from 1 to 250 significant digits. In advance some useful constants like PI, Ln(2), Ln(10) are provided with up to 400 digits.

For Linear Algebra the main topics are: System resolution with Gauss-Jordan algorithm, Matrix Addition and Multiplication, Determinant, Matrix Inversion, Crout's algorithm for LU decomposition, LL Cholesk decomposition, Similarity Transform, Matrix power.

For this addin, multiprecision numbers are strings containing:
• Up to 250 mantissa digits.
• Sign character "+" or "-"
• Decimal symbol (default ".")
• Exponent symbol "E" or "e"
• Exponent sign character "+" or "-"
• Up to 10 exponent digits

for a total length of 214 characters.

The functions recognize both decimal format (12.34 , -0.056, etc.) and exponential format (1.234567E-015). In addition, the functions accept decimal, double, currency or any other standard Excel number type, or even mixed (extended + normal) numbers.


There's also an updated version maintained by some one else

http://www.thetropicalevents.com/


Paul