+ Reply to Thread
Results 1 to 4 of 4

dealing with very long numbers

  1. #1
    Registered User
    Join Date
    07-07-2005
    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

  2. #2
    bj
    Guest

    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
    > View this thread: http://www.excelforum.com/showthread...hreadid=385194
    >
    >


  3. #3
    Jerry W. Lewis
    Guest

    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

    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. #4
    Bernard Liengme
    Guest

    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
    http://www.mupad.org/download/
    best wishes
    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "149047" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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 to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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