# Excel sort with formula in cell

When I have a formula in a cell (the list is about 8,000 long, I go to try and sort it from most to least, however when I do this it will not sort, I believe it is because there is a formula in the cell, is doing it the normal way of clicking on the cell(s) and using the ribbon. Is there a special way of doing it when a formula is involved?

Thanks

## Have an answer?

JD