"Harlan Grove" schrieb im Newsbeitrag
...
"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.
Hi Harlan
I guess they just forgot to update the KB article :-)
So Excel 2003 still has this bug (at least my German version). Not sure
what the max. allowed number in previous versions is so I couldn't test
if they at least extended the value range (but I doubt it)
Frank