Right(C1;6)+0 will convert the values in C to numbers, which should then match up with the values in A.