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

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

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

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