You would need to convert the functions to values prior to sorting, since
sorting usually forces a recalc.

Bernie


"ret415" wrote in message
...


"Erick K" wrote:

After generating a column of numbers using the random number generator in
Excel, I tried to sort the column low to high. The sort appears to be
random and additional sorting only yields a random column of numbers.
How do
I fix the numbers for normal sort?