How To Handle Large Numbers?

  • Thread starter Thread starter bw
  • Start date Start date
B

bw

A3 = 123456789012
MOD(A3,10) = #NUM!

How do I handle situations like this when numbers are large? Why does it
make any difference what size the number is?
I want to be able to perform operations like this on 13 digit numbers
(unless you suggest a better way).

Thanks,
Bernie
 
Hi
this is a known bug of the MOD function. One possible workaround
=A3-INT(A3/10)*10
 
Back
Top