I have a code in which the first 2 digits represent the year. I.E. 8040121011 would represent 1980. I understand that the function left(a1,2) would return 80 for 1980. However, I need to return 1980. Is there a way in which I can use another formula as well to combine with the left function and get 1980?
Thanks for your help.
Thanks for your help.