Hi
you can't delete the 'values' from a formula. The formula will always
calculate its result

--
Regards
Frank Kabel
Frankfurt, Germany

"dranreb" schrieb im Newsbeitrag
...
I wanted to clear the values in a spreadsheet without deleting the
formulas
or formatting in the spreadsheet. For example: A budget sheet made
for every
year, the formulas and formatting remains the same, only the values
change.
I tried paste special formulas....in this case, if values are
present, they
get copied too.