A BIG THANK YOU! The problem was that the numbers were stored as text and there is a convert text to numbers under the data tab. I never thought of the numbers would be stored as text.