Deleting the DATA but NOT the Formulae!
 

Folks ---
I have a spreadsheet that got -- to understate the matter, delicately -- the
wrong
data pasted into it. I need to delete JUST the numbers, but leave the
recalculation
logic in place. How does one do this?

Thankx in advance from the Big Gray Cat.

Deleting the DATA but NOT the Formulae!
 

Press F5
Click on Special
Check the Constants option
Click Ok
Press Delete

"Big Gray Cat" wrote:

Folks ---
I have a spreadsheet that got -- to understate the matter, delicately -- the
wrong
data pasted into it. I need to delete JUST the numbers, but leave the
recalculation
logic in place. How does one do this?

Thankx in advance from the Big Gray Cat.