And if that is not good enough, you might look at the Mersenne Twister

http://www.math.sci.hiroshima-u.ac.j...at/MT/emt.html
http://www.math.sci.hiroshima-u.ac.j...S/FORTRAN/fort...
http://www-personal.engin.umich.edu/...neTwister.html

which is implemented in the freeware NtRand

http://www.numtech.com/NtRand/


Also note that the improved algorithm in 2003 only applies to the
worksheet function RAND(), not to the VBA or ATP random number generators.

http://groups.google.com/groups?selm...9.36e9afd8%40p...

implements the 2003 algorithm in VBA.

Jerry

Michael R Middleton wrote:

Mike -

Maybe the simplest way to "enhance" Excel's random number generator is to
use Excel 2003:

http://support.microsoft.com/default...b;en-us;828795

- Mike

www.mikemiddleton.com


"Mike" wrote in message
oups.com...

Hi everyone:

I found this information on how to enhance Excel's RNG:

http://support.microsoft.com/default...Ben-us%3B86523

How can I take advantage of this to enhance my excel RNG?

Thanks,
Mike