"Anne Troy" wrote in message
...
Bill: Whenever you sort, as a rule, don't select the area (column) you're
sorting by. If you simple click in, for instance, B2, and hit the sort
button, the numbers should sort right along with the colors (and stay with
them). However, your numbers can't be "calculated". In other words, if you
have 200 in A2, and =A2+1 in A3, you must first convert these formulas to
numbers by copy/edit/paste special, values, OK.
************
Anne Troy
www.OfficeArticles.com

Thanks Anne

That's why they wouldn't sort, I did use a formula to run the numbers down.
I will try and change them to numbers not formula.

Thanks again
Bill