Normally problems like this are from people who like to put a space before or after text. If you use the Trim() function on a whole column and then paste values only on top of the column, it will take care of many of these data entry problems. If you have values then converting the text to numbers is what I'd do to insure you remove those text cells that you think are numbers. I've seen people who use the letter "oh" instead of zero because it looks the same to them. These are the same guys who use lower case L instead of one. The computer knows the difference.