Half way there, deleting numbers but keeping the formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thanks Paul and Niek...I need to clarify. I have some blocks with numbers and some with numbers and formulas. I want to keep the formulas, and remove the numbers, so I and just go in and add this months numbers and start with a clean sheet....but not have to replace the formula. I hope I am explaining this correctly. When I did the edit...., special...., it only removed either or but would not leave the formula.


Thanks
 
Vince,

There's no way to do what you're asking, per se.
The values that you see are the result of the formulas.

One way around this is to rework all of your formulas with an IF
statement to show up as blank dependent on another value.

Let me explain that....
Let's say that you have a lot of entries on a sheet and a total
somewhere (for the sake of argument("A1").

Your formula could read:
=IF("A1" = "","",youroriginalformula)

Until A1 has something in it, your formula cells will show nothing.

John

Vince said:
Thanks Paul and Niek...I need to clarify. I have some blocks with numbers
Click to expand...
and some with numbers and formulas. I want to keep the formulas, and remove
the numbers, so I and just go in and add this months numbers and start with
a clean sheet....but not have to replace the formula. I hope I am
explaining this correctly. When I did the edit...., special...., it only
removed either or but would not leave the formula.
 
Back
Top