View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] mattsteel101@gmail.com is offline
external usenet poster
 
Posts: 1
Default how do I delete data in a cell without deleting formula?

On Sunday, April 20, 2008 at 11:07:25 PM UTC+1, David Biddulph wrote:
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.


That is rubbish David