Delete content of cell without erasing existing formula?

D

duethckey

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
 
G

Gord Dibben

F5>Special>Constants>OK.

Edit>Clear Contents


Gord Dibben MS Excel MVP

Gord Dibben MS Excel MVP
 
Top