Hi I have this list:
532790M
47448M
378267M
467981M
53661M
583783M
524687M
390963M
493436M
185366M
150370M
497092M
3660G
568961M
152693M
254278M
353173M
I am running an Access Query and I am trying to figure out what criteria do I need to insert for just showing only two digits before "M" and "G".
Thanks