View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 293
Default Delete cell value but keep formula in cell.

Hi Lofred,

Not possible - formulae necessarily return the results of their calculations. You could, of course, delete the data the formula
refers to.

--
Cheers
macropod
[Microsoft MVP - Word]


"Lofred" wrote in message ...
After the formula in a cell has calculated a value I would like to reset the
cell for the next use by deleting the value but keeping the formula in the
cell.
Is this possible in Excel 2007?