How do I clear the numbers in the cells but keep the formulas?
A AKphidelt May 14, 2007 #2 That doesn't make sense. To clear the numbers in a formula you would clear the numers the formula is referring to. Or is there something else you're trying to do?
That doesn't make sense. To clear the numbers in a formula you would clear the numers the formula is referring to. Or is there something else you're trying to do?
D Dave Peterson May 14, 2007 #3 Maybe you can adjust your formula so that the cell looks empty under certain conditions: =if(a1<10,"",yourformulahere) (for example)
Maybe you can adjust your formula so that the cell looks empty under certain conditions: =if(a1<10,"",yourformulahere) (for example)
G Gord Dibben May 15, 2007 #4 Maybe F5>Special>Constants? Check/uncheck the options and OK. Edit>Delete. Formulas will remain untouched. Gord Dibben MS Excel MVP
Maybe F5>Special>Constants? Check/uncheck the options and OK. Edit>Delete. Formulas will remain untouched. Gord Dibben MS Excel MVP
