You can also just not copy the = or edit it out after pasting the formula.

If this is just for occasional reference and not something to takeup space
all the time, it may be worth looking at Tools>Options>View & put a check in
the box for Formulas, go back and remove the check when you're done.
Keystroke: Ctrl+` (Grave Accent, right above the Tab key) to toggle formulas
on/off.

Hope this is of use to you |:>)

"BenjieLop" wrote:

>
> Audrey Wrote:
> > Is there an easy way to copy formulas as text to other cells (for use as
> > a
> > reference)?
>
> Put an apostrophe before the formula and it will be converted to a
> text.
>
>
> --
> BenjieLop
>
>
> ------------------------------------------------------------------------
> BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
> View this thread: http://www.excelforum.com/showthread...hreadid=345999
>
>