Anna,

As you correctly observe the numbers change because the sort causes the
worrksheet to recalculate. There are a number of ways around it.

One suggestion is copy your random numbers and paste special/paste values
into another range and then sort this range
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Anna" wrote:

How do you use the sort filter smallest to largest? When I try I see that
the numbers are changing not just reordering? Any ideas?