This Excel tutorial explains the algorithm of HKID Check Digit (last digit) and provide a custom Access Excel VBA Function to verify the Check Digit. (香港身份証最後號碼)
You may also want to read:
Access Excel Generate random HKID Hong Kong ID card number
HKID Check Digit
Hong Kong ID card number has a last digit with bracket called "Check Digit". Check Digit is a number to verify if the previous number and alphabet are correct. By understanding the algorithm of calculating Check Digit, you ...
Read More