Copy cell values, not formulas - Support

Sometimes, when you copy the contents of a cell, you want to paste just the value and not the underlying formula ... For example, you might want to copy the resulting value of a formula to a cell on another worksheet. ... Applies To: Excel 2007.

support.office.com