# dealing with very long numbers

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

2. ## RE: dealing with very long numbers

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
>
>

3. ## Re: dealing with very long numbers

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

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 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. ## Re: dealing with very long numbers

In addition to Maple, Mathematica there is also MuPAD - a open access CAS
from Europe. There is a FREE, light version available at
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"149047" <149047.1rsqic_1120734321.2428@excelforum-nospam.com> wrote in
message news:149047.1rsqic_1120734321.2428@excelforum-nospam.com...
>
> 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
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1