They have to be text AlKey because as I mentioned sometimes they will have a letter (G or AG) attached to them. Your method doesn't work when I attached a G to the end.

Xor, I tried to paste as values (which probably made them back into numbers huh?) I also tried changing the format at the top to text. What do you suggest? I have to save as text or a "string" because of the mix of letters and numbers, but this was so straightforward it confused me.