When copying from the formula bar, don't forget to hit <Enter or <Esc
before pasting to the new cell.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Dave Peterson" wrote in message
...
If you only have one formula to copy|paste, then copy from the formula bar
and
paste into the formula bar.

If you have lots, you can change the formulas to text:
edit|replace
what: =
with: $$$$$= (some unique string)
replace all

copy|paste normally

edit|replace
what: $$$$$=
with: =
replace all
(both in the source and destination ranges)

Kinjalip wrote:

Is there a way to copy a formula from one cell to another cell to get the
same answer. When attempting to copy a formula from one cell to another,
the
column and row destinations are changing in the formula, with a result of
0
not he original solution.
Thanks
--
Jeffrey L. Lippard, A+ certified, CHDP certified

--

Dave Peterson