Hello

I found a post where ChemistB advised on a very cool custom validation formulae to limit to a list as well as ensure proper case. I've used the same but for upper case with some of my cells:
=And(IsNumber(Match(K14,Values!$F2:$F6,0)),Exact(K14,Upper(K14)))
But now I have a scenario where the valid list could have numbers or alpha characters though all should be saved as text. The above would work if the list was entirely text but if the entry is a number the user is forced to enter a single apostrophe first so the number is saved as text. How can I get around this?

Thanks very much.