"Gold Fish" <Gold wrote...
Excel is not able to make computations using the MOD function of numbers as
large as 10 billion. So for example if we type in
=MOD(10000000000,10)
We get a result of
#NUM!
....

Old news.

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

This KB article implies by omission that this has been fixed in Excel 2003,
but if so there ain't gonna be a fix for older versions.