In excel how do remove a cel's content, but keep the formula?
 

I have to keep the formulas in a template, but want to remove the value from
the cel. For example, I don't want someone to see the calculation total the
formula has given me, I just want them to see the formula. Or conversly, hide
the formula and the answer. It is important that I can put in the new users
data and the formula will auto calculate the new answer based on their inputs.

In excel how do remove a cel's content, but keep the formula?
 

Edit/ Go To/ Special/ Values
Delete
--
David Biddulph


"veneziagurl" wrote in message
...
I have to keep the formulas in a template, but want to remove the value
from
the cel. For example, I don't want someone to see the calculation total
the
formula has given me, I just want them to see the formula. Or conversly,
hide
the formula and the answer. It is important that I can put in the new
users
data and the formula will auto calculate the new answer based on their
inputs.

In excel how do remove a cel's content, but keep the formula?
 

Make that EditGo ToSpecialConstants and uncheck all but "Numbers"


Gord Dibben MS Excel MVP

On Wed, 10 Dec 2008 09:30:01 -0800, veneziagurl
wrote:

I have to keep the formulas in a template, but want to remove the value from
the cel. For example, I don't want someone to see the calculation total the
formula has given me, I just want them to see the formula. Or conversly, hide
the formula and the answer. It is important that I can put in the new users
data and the formula will auto calculate the new answer based on their inputs.