Copy Data in Cell not Formula

[matethreat]

Hello,

This might be a fairly straight forward question, but I can't seem to come up with the solution.

I am looking to copy the contents of a calculated cell. I just want the values in the cell copied and not the formula used to derive the number in it. So that the number now stands on it's own and is not dependant on the values of any other cells.

Thanks,

Aaron

 

[medic133]

Aaron,

Copy the contents of the calculated cell by highlighting it. Then click in the cell in which you want to paste the value of the calculated cell. Click Edit on the menu bar and select Paste Special. In the dialog box that opens select Value under the paste section. Make sure None is selected under the Operation section (this is the default). Click OK. You can see in the dialog box that there are several other operations that you can perform while pasting that will benefit you under various circumstances. Hope this answers the question!

 

[matethreat]

Thanks medic133,

I knew it was simple, just having a brain freeze.

Aaron