A 2,147,483,648 SD Edition of xlPrecision is available for
use in your programming code. Yes, that's over TWO
BILLIONsignificant digits. Of course, you can also use any other
edition of xlPrecision in your programming code.

For Pure Mathematics

The 2,147,483,648 SD Edition was created at the request of a number
theorist in Germany, who needed at least 110,000 significant digits, and
possibly more, for his
Number Theory project. Number Theory is a branch of
Pure
Mathematics. Although most customers of this edition use it for number
theory, it is also in use by at least one customer for
Combinatorics, another branch of pure mathematics.

Some Functions Limited to 32,767 SD

Some xlPrecision functions are currently limited to 32,767
significant digits even in the 2,147,483,648 SD Edition, because they or another
function they depend on are stored
as 32,767-digit constants in the DLL file. A 2,147,483,648-digit constant would make the DLL
file extremely large.

To work around this limitation, if there is demand for it, I could add an
option to get the constants from text files,
which you could download and truncate to the desired length;
let me know if you'd like that.

The affected functions are:

xlpPI (stored as a 32,767-digit constant)

xlpE (stored as a 32,767-digit constant)

xlpEXP, xlpLOG, and xlpLN (depend on LN(2) and LN(10)
which are stored as 32,767-digit constants)

This edition is intended for use in your
programming code, such as VBA. Use
caution if using the 2,147,483,648 SD edition within an Excel worksheet, because
Excel worksheets cannot accept more than 32,767 characters per cell.

Why Exactly 2,147,483,648 Significant
Digits?

xlPrecision numbers are stored and manipulated internally as text
strings, and xlPrecision's programming environment does not permit text strings
longer than 2^31 characters long. 2^31 (two to the thirty-first power) is
2,147,483,648. It may be possible to make an edition that is limited only by
memory by using arrays of those text strings, but it would take some work to get
all the math procedures to work with those arrays, and I don't think there is
any need to exceed that limit.

Word VBAIf using the
2,147,483,648 edition in Word VBA, note that Word VBA's
TypeText method is limited to 64k, which on
unicode versions of Word (such as Word 2003) is 32,767 characters.
If you exceed that, it starts over; for example, if you give it 32,769
characters, it returns only the first 2 characters (32,769 - 32,767 = 2).

To work around that limitation (bug?), use Word VBA's InsertBefore method instead of
TypeText. Or, if InsertBefore
doesn't suit your needs, another approach would be to loop through the
text 32,767 characters at a time, using Mid to get a 32,767-character
chunk, and doing a TypeText on that chunk, each time through the loop.

The 2,147,483,648 SD Edition is available as a Free
Edition, an Express Edition, a Research Edition, and a Site License:

2,147,483,648 SD Free
Edition

Please note: the
2,147,483,648 SD Free Edition is more restricted than the standard, 3,000 SD
Free Edition -- it requires a confirmation code
every calculation instead of every 5th calculation, the confirmation
codes start at 5 characters instead of 3, and the confirmation codes
grow by 5 characters with each calculation instead of by 1 character.

Licensed for use only by licensee and
licensee's immediate family members living in the same domestic residence as
licensee. May be installed on as many computers as desired, but only ONE
COPY may be in use at any time.

Licensed for use only by licensee and licensee's immediate
family members living in the same domestic residence as licensee. Licensee (and licensee's immediate family members living
in the same domestic residence as licensee) may use an UNLIMITED NUMBER OF
COPIES SIMULTANEOUSLY.