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
Printable View
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
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/...g-answers.aspx
Mark
If you're looking for more that 15 digits of computational precision, there is an add in you can look atQuote:
Originally Posted by rangudu_2008
http://digilander.libero.it/foxes/MultiPrecision.htm
From the intro page
Quote:
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