Copy-paste excel data without changing the content

Here's what I usually do in that circumstance....

From the ribbon:
Home.Find&Select.Replace
...Find what: =
...Replace with: |=
...Click: Replace_All

That will prepend every equal sign with a pipe character.

Now you can copy and paste whatever you want...since all formulas are now text.

When done:
Home.Find&Select.Replace
...Find what: |=
...Replace with: =
...Click: Replace_All

(Original webpage: http://answers.microsoft.com/en-us/office/forum/office_2007-excel/copy-paste-excel-data-without-changing-the-content/da4ec7d9-460c-4927-af2d-0d9d2bdaa92d)