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

Regards
FSt1
"Gumby" wrote:

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?