Thread: Delete content of cell without erasing existing formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Delete content of cell without erasing existing formula?
F5SpecialConstantsOK.

EditClear Contents


Gord Dibben MS Excel MVP

Gord Dibben MS Excel MVP

On Mon, 22 Oct 2007 10:02:01 -0700, duethckey
wrote:

I copied a file.
I would like to erase the number in the copied cell but save the formula.
When I hit clear contents it also erases the formula??
Thx

Reply With QuoteReply With Quote