That is exactly what I did, with the same results and is how I knew the rows were text. What I find odd is that you find this surprising and abnormal. How on earth would you expect Access to convert text to any type of number when the text doesn't resemble a number? 123 as text will covert to a number, but what number is "apple"?