And if you have range of cells to do this to, then select the range and do
Edit / Replace / Replace = with %%. Copy to new place, and then do Edit /
Replace / Replace %% with =.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Ragdyer" wrote in message
...
Select the entire formula in the formula bar.

Right click in the selection, and choose "Copy".

Hit <Enter.

Right click in J10, and choose "Paste".

And you're done.
--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Gary's Student" wrote in message
...
I would like to copy the formula in one cell to another without
adjusting
cell references within the formula. For example

Cells(10,10).formula=cells(2,2).formula

will copy the formula in B2 to J10 without adjustment. There must be a
simple way to do this without resorting to VBA??

--
Gary's Student