Hi, >If I put the functions in say A1;A12 and then put =A1;A12 into cells B1;B12 >and then try to sort the same thing happens. How can I remove the data from >the undelying function in order to use it
So far all correct, now, copy a1;a12 and say you want to paste into f5;f16 then, right click on f5 and on the popup menu see the last option "Paste Special". click that, you get a dialog with many check boxes, UNCHECK ALL and then just check numbers that does it. JS
