Copying Numbers in cells, without the formula

Posted by David on December 20, 2001 2:35 AM

Cant anybody tell me if it is possible to copy the number from a cell, without copying the formula aswell, for example, if ther is a formlua in cell A1 which makes a number appear in A1, is it possible to copy cell A1, and when you paste it for the number to appear and not the fromula? please reply asap if you can help, thanks

Posted by Ampleford on December 20, 2001 3:17 AM

Paste Special

Select "Copy" with the right mouse button on the cell with the formula, then, when you go to the destination, just right-click again and select "Paste Special" and finally click on the Radio Button for "Values"

Hope that works