I need to calculate the check digit using the Luhn Algorithm (AKA Luhn 10 or Modulus 10) for a given number to oblige to format of the OCR line on the payment slip of Danish "FI-kort". This would allow creation of invoices with a valid payment slip identifying the debtor and payment purpose via a number automatically inserted on the bank account statement. I plan to use a spreadsheet with the required fields to create invoices using a mail-merge procedure. The calculation is possible using a rather complex formula. As the Luhn Algorithm also is used to validate Credit Card numbers and a number of other purposes I had hoped to find a function, that would easily calculate the required digit and perhaps a related function that would determine whether a given number is "valid" (ie check that the number passes the Luhn Algorithm test). Any suggestions on how to handle this challenge? Is there an AddOn somewhere, that would do this for me? (Have searched but not found)
Thank you, Karl Lausten --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
