View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default how do I delete data in a cell without deleting formula?

A cell contains either formula or data. It can't contain both.
--
David Biddulph

"tripy" wrote in message
...
after adding data to a formulatted cell on a worksheet, i save as, and
then
use the previous worksheet and delete data to start another worksheet.
when
doing this I also delete the formulas, which I don't want to do- go to
question.