I think your numbers are really text values that look like numbers, for
it to sort in the way you say.

Pete

Dawn wrote:
help! I can't seem to get excell to sort in real numerical order ie 1, 2, 3,
4, 5 and NOT 1, 10, 100, 2, 20, etc. my data is definatatly sorted in
number format
Using excell 2003
hope someone can help
thanks
Dawn