Home |
Search |
Today's Posts |
#1
|
|||
|
|||
dealing with very long numbers
hi all! i would like to be able to use and calculate with very long numbers in excel (up to 100.000 digits) how can this be achieved? i am no big excel makro writer - so can someone guide me ??? :) ps: the numbers i get are take from text files. thx markus -- 149047 ------------------------------------------------------------------------ 149047's Profile: http://www.excelforum.com/member.php...o&userid=24989 View this thread: http://www.excelforum.com/showthread...hreadid=385194 |
#2
|
|||
|
|||
Excel will only handle up to 15 digits at a timeas a number.
you will need to set up rather complex systems to do even simple math from long text files of digits. is it doable? yes, but there are probably better programs for doing the programming in. "149047" wrote: hi all! i would like to be able to use and calculate with very long numbers in excel (up to 100.000 digits) how can this be achieved? i am no big excel makro writer - so can someone guide me ??? :) ps: the numbers i get are take from text files. thx markus -- 149047 ------------------------------------------------------------------------ 149047's Profile: http://www.excelforum.com/member.php...o&userid=24989 View this thread: http://www.excelforum.com/showthread...hreadid=385194 |
#3
|
|||
|
|||
Excel's documented limit is 15 digits; you cannot change that. You
could enter longer numbers as text, but could not calculate with that extra precision. Through VBA you could use up to 28 digits (no scientific notation or math functions other than +-*/) with the Decimal data type. I've never used it, but the XNUMBERS add-in claims to handle numbers up to 200 digits, and includes transcendental math functions: http://digilander.libero.it/foxes/index.htm You can download a 64 digit calculator from http://www.crbond.com/applications.htm but the version I tried did not support copy/paste. I don't know what a fractional digit would be in your context, so I assume that you want to deal with 100000 (10^5) digits, although I can't conceive of an application that would need that (far too few digits for calculating any natural constant to record precision, and far to much for just about anything else). For that kind of precision, you might do better to look at symbolic engines with arbitrary precision, such as Maple or Mathematica. If you are not prepared to spend $$, you might try Maxima http://maxima.sourceforge.net/ but the interface is a bit dated. Jerry 149047 wrote: hi all! i would like to be able to use and calculate with very long numbers in excel (up to 100.000 digits) how can this be achieved? i am no big excel makro writer - so can someone guide me ??? :) ps: the numbers i get are take from text files. thx markus |
#4
|
|||
|
|||
In addition to Maple, Mathematica there is also MuPAD - a open access CAS
from Europe. There is a FREE, light version available at http://www.mupad.org/download/ best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "149047" wrote in message ... hi all! i would like to be able to use and calculate with very long numbers in excel (up to 100.000 digits) how can this be achieved? i am no big excel makro writer - so can someone guide me ??? :) ps: the numbers i get are take from text files. thx markus -- 149047 ------------------------------------------------------------------------ 149047's Profile: http://www.excelforum.com/member.php...o&userid=24989 View this thread: http://www.excelforum.com/showthread...hreadid=385194 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
How do you convert numbers as "text" to values for a long column . | Excel Discussion (Misc queries) | |||
Long numbers show up as Scientific Notation | Excel Discussion (Misc queries) |