I need to change the values to zero but leave the formulas with out going
through 400 spreadsheets and manually putting in a zero into each cell....
can this be done? If this does not make sense please let me know and I can
try to explain it! Thanks again all!!!

Example:
I have a spreadsheet that I enter the sales data on a monthly basis. Now for
2006 I wanted to just copy each customer file and change the sales info to
zero to start the new year...

Hope this makes sense!! :o)

April