I want to copy and paste the displayed results in a number of cells rather than the various formulas located in those cells.
Have you tried clicking the down arrow next to the paste icon and selecting Unformatted Text, or Paste only Numbers? Also in the menu Edit | Paste Special
or Ctrl+Alt+V and selecting from there. Cheers, Al