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
Try Ctrl+Shift+V or choose submenu Edit-Paste Special