Forum Discussion
Formula required
The last two digits of the student number indicate the year the student enrolled. In F4 create a formula that will put "20" followed by the last two digits of the Student ID, e.g. 2015. Copy the form...
=NUMBERVALUE("20"&RIGHT(A2,LEN(A2)-FIND("/",A2)))You can try this formula. What is the expected result of the check digit in S6?
Thank you. It worked
