For an IBAN Validation, I need to calculate the modulo of a very large number. What I am doing is simply

Example:

with A1 = 210501700012345678131468

=mod(A1;97)

The result should be 1. Instead it result in #NUM

Obviously my value in A1 is too large for sheets. How can I "help" sheets?