One way:

Remove the = sign before copying and re-insert it in the new location after pasting

Manually.............just preface the formula with an apostrohe.

Copy and paste then remove the apostrophe from both spots.

For another manual method of copying multiple formula cells see John
Walkenbach's site.

http://www.j-walk.com/ss/excel/usertips/tip066.htm

By VBA macro for a single cell.

Sub CopyFormula()
Dim X As New DataObject
Dim CelCopyTo As Range
   X.SetText ActiveCell.Formula
   X.PutInClipboard
   On Error GoTo endit
   Set CelCopyTo = Application.InputBox( _
           prompt:="Select the CELL" _
           & "to which you wish to paste", _
           Title:="Copy Cell Formula", Type:=8).Cells(1, 1)
   X.GetFromClipboard
   CelCopyTo.Formula = X.GetText
endit:
End Sub

Gord Dibben  MS Excel MVP

Highlight the formula in the formula bar.

Either right click>Copy or Edit>Copy. Hit escape.

Then paste the formula wherever you want.

Of course, this doesn't help if you want to copy a whole block of formulas.

If you have downloaded the asap exe file, click on it (best when excel is
not open), and follow the instructions. There are step by step instructions
on the site.
http://www.asap-utilities.com/installation-step-by-step.php
You will have a new menu item in excel, called ASAP utilities. In this are
many things which are not available, at least with a couple of clicks, in
excel normally.
I use the convert numbers to text, creating an index sheet, and several
others regularly.
In the ASAP utilities in your excel menu is a link to the user guide (in pdf
format).
Hope that helps,
Barbara

After placing the cell in edit mode (F2, etc.), you can highlight the
formula in the cell or in the formula bar, copy, press escape and paste
where you want. Excel will not alter the relative addresses.