mhenk
Unless later versions of Excel work differently than 2000 does (and you happen to have that version), Domenic's suggestion won't work because the replace function is looking for "text" that says "#DIV/0!" not the results of the formula yielding and error message that displays those characters... does that make sense?
Unfortunately, I don't have enough programming skills to help you with your existing 791 sheets. If a more experienced member can't devise a fix for you, I can at least suggest a solution to prevent it in the future. I don't know how extensive your formulas are throughout the existing template, so this might not be pracitical. But, if it is, you can alter both the format of the cells and the formulas themselves to produce the desired results in the future.
For example:
Let's say the current formula in A1 is "=B1/C1". If C1 is empty or equals zero, then A1 displays " #DIV/0! " because you can't divide by zero or nothing. What you want to do is force the formula to always result in zero and then format the cell to be blank whenever it does.
If you change the formula to "=IF(C1,B1/C1,0)", A1 will always have a number displayed. If it's a real number then it's the real number, if it's a number divided by zero or nothing, the result will be zero.
If you don't want the zero to be displayed, the next step is to change the number format. I don't know what number format you're using but let's say positive numbers are black and display as 00.00 and negative numbers are (00.00) and red in color. Your custom format to have zeros displayed as a blank cell would be: 00.00;[Red](00.00);
To change your format, click Format > Cells > Number... Choose Custom for the Category and in Type, type "00.00;[Red](00.00);"
I prefer to have a hyphen displayed, rather than a blank cell (so I am certain the cell still has a formula in it and is not empty). So my custom format would be:
"00.00;[Red](00.00);-"
But again, you'll have to determine how time effective this revision this would be for you. The new formula is dynamic so can be cut/pasted, filled, dragged, etc. like a normal formula and any text combination can be added after the third ";" in the custom format to replace a zero... I have some that say "n/a", "NONE", and for percentages, "EVEN".
Hope this helps... Krys
P.S. As always, don't include the quotation marks when entering the above text strings.