Then you need to look at your data. Perhaps you have leading or trailing
spaces in column A, or perhaps some of your numbers entered as Text.

To check the latter, try copying a blank cell, selecting your numbers,
then choosing Edit/Paste Special, selecting the Values and Add radio
buttons. This will coerce any text values to numeric.

In article ,
knbsmith11 wrote:

I tried it, and it gave me the wrong answer.