Clear values but keep formulas?

G

Gumby

I have created a work sheet where now I would like to delete all the values
but keep all the formulas. Can this be done?
 
F

FSt1

hi
try this
press F5 to get the goto dialog.
click the special button at the botton
select contrants>ok
you have select all non-formula cells.
hit the delete key
you may get a few #DIV/0! errors

Regards
FSt1
 
Top