software

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!! )

April

April,

Select all the cells of mixed formulas/ vlues, then use Edit / Go To... Special Constants (and
then select numbers, or strings as appropriate) then press 0 and Ctrl-Enter or just press Delete.
Make sure that you don't select cells with headings, labels, etc....

HTH,
Bernie
MS Excel MVPquot;DestinySkyquot; gt; wrote in message
...
gt;I need to change the values to zero but leave the formulas with out going
gt; through 400 spreadsheets and manually putting in a zero into each cell....
gt; can this be done? If this does not make sense please let me know and I can
gt; try to explain it! Thanks again all!!!
gt;
gt; Example:
gt; I have a spreadsheet that I enter the sales data on a monthly basis. Now for
gt; 2006 I wanted to just copy each customer file and change the sales info to
gt; zero to start the new year...
gt;
gt; Hope this makes sense!! )
gt;
gt; April