Hi,

Test this on a non-critical workbook

tap F5
Click 'Special'
Select 'Constants'
Un-check 'Text' and 'Logicals'
OK
Tap delete

Mike


"denvancam" wrote:

I am trying to save last years workbook, that accumulates data and totals
numbers. I need to erase last years inputed data, but want to keep the
formulaes intact. If I delete the data, it deletes the formulaes, if i clear
contents it does the same to the formulaes. I don't want to re-input the
same formulaes for every month in the year data base.