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
formulas and text intact. If I delete the data, it deletes the formulas, if I clear contents it does the same to the formulas. I don't want to re-input the
same formulas for every month in the year data base.

I ran across the following for Windows and was hoping someone could help me with a similar method for Mac. That is, if the following works at all.

F5
Click 'Special'
Select 'Constants'
Un-check 'Text' and 'Logicals'
OK
Delete