Okay, Bill. Just be sure to select all the cells that contain formulas. Hit
Ctrl+C. Don't move! Then hit Edit--Paste Special, choose Values, and hit
OK. Now the formulas are gone and the numbers remain.
************
Anne Troy
www.OfficeArticles.com

"Bill" wrote in message
...

"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