when i apply the MOD function in a number>100000000000 returns #NUM
F Frank Kabel May 4, 2004 #2 Hi this is one annoying problem of Excel's MOD implementation. It can't handle large numbers
D Dana DeLouis May 5, 2004 #3 Here's a good kb article: XL: MOD() Function Returns #NUM! Error Value http://support.microsoft.com/default.aspx?scid=kb;EN-US;119083
Here's a good kb article: XL: MOD() Function Returns #NUM! Error Value http://support.microsoft.com/default.aspx?scid=kb;EN-US;119083
