SoftMaker.com

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.

$12,248.12
$2,463.53
$8,164.85
$5,470.40
$28,346.90

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:

#REF!
#REF!
#REF!
#REF!
#REF!

How can I get the results that I can see in Notepad into a new spreadsheet?

Thank you for your time and interest!

Peter

_________________
Cheers,

Peter

Hello Peter,

To do this you need to use the "Paste Special" command. Highlight the cells you want to copy & copy them - then, when you want to insert them click the location and go to the EDIT menu, select "Paste Special" and make sure the box marked "Convert formulas to values" box is checked (ticked) - then press ok.

Hope this helps.

Glenn

Thanks very much Glenn. You certainly cleared that up for me pretty quickly!

Cool!

_________________
Cheers,

Peter

You may also customize your PlanMaker toolbar with the insert button that inserts values only.