Perhaps this Microsoft Knowledge Base article explains:
http://support.microsoft.com/kb/119083/EN-US/
"If the divisor argument, multiplied by 134,217,728 (or 2 raised to
the 27th power), is less than or equal to the number argument,
the MOD() function returns a #NUM! error value.
HTH,
--
Kevin James.
Tua'r Goleuni
"J.H." wrote in message
...
|I have a question on the funtion "MOD". When the number to be divided is more
| than nine digits (like: 1,234,457,890), the funtion would return error. How
| can I fix this?
|
| Thanks.