If i have a row of say 50 numbers tat are all generated by RAND() How can i sort these numbers but not have them refresh. At the moment everytime i do something the numebrs change. Thanks
OH found out how to do that just use special paste and select values and not formula. The next problem is i need a list of 100 numbers between 99.99 - -99.99 All numbers must be availble to be included including 0 exactly