Copy Formula   

I have a formula in a cell.  The formula is:  =150+200
I wish to copy that formula and place it in another workbook as =150+200 and 
not the resulting value 300.  How do I do this?

date: Tue, 7 Oct 2008 07:47:02 -0700   author:   Mike H.

RE: Copy Formula   

copy - pastespecial formulas.


"Mike H." wrote:

> I have a formula in a cell.  The formula is:  =150+200
> I wish to copy that formula and place it in another workbook as =150+200 and 
> not the resulting value 300.  How do I do this?

date: Tue, 7 Oct 2008 08:15:01 -0700   author:   dmoney

RE: Copy Formula   

Select the formula in the edit mode (not the value)
Go to the cell you want it in
Type ' then CTRL-V and ENTER

btw 150+200 is 350 :-)

"Mike H." wrote:

> I have a formula in a cell.  The formula is:  =150+200
> I wish to copy that formula and place it in another workbook as =150+200 and 
> not the resulting value 300.  How do I do this?

date: Tue, 7 Oct 2008 08:19:00 -0700   author:   Sheeloo