Hello Plan People:
I am sure that this function exists, but I am not sure how to get it to work.
I would like to be able to copy the results of a calculation, so that I can paste them as numbers somewhere else.
For example, these numbers appear in a column of cells. Each number is the result of a formula. The formulas can be the same, or different; that is not relevant. What I need to copy, then paste somewhere else, are the numbers in this little list. Once copied, I will need to use them as numbers, not text.
Using Copy-and-Paste, they will happily reproduce, as a list of numbers, in Notepad.
However, If I need those numbers (not the formulae that produced them), in a new Spreadsheet, the Copy-and-Paste operation produces:
How can I get the results that I can see in Notepad into a new spreadsheet?
Thank you for your time and interest!