You would need to post your formula for a specific suggestion but as a
generic suggestion try something like this:

=IFERROR(your_formula,"")

Note that this will only work in Excel 2007. For something that's compatible
with all versions of Excel:

=IF(ISERROR(your_formula),"",your_formula)

#DIV/0! errors are caused by trying to divide something by 0. You can also
just test that a certain cell is not empty/contains 0. For example, you have
a formula like:

=A1/B1

If B1 is empty/contains 0 you'll get the error. You can test B1 to trap the
error:

=IF(B1=0,"",A1/B1)


--
Biff
Microsoft Excel MVP


"myssieh" wrote in message
...
Good afternoon...

I am running Office 2007 on Windows 2007. Is there a way to keep #Div/0!
from showing up. The cells are currently blank but will be populated
eventually. We want as much automation as possible by going ahead and
loading the formulas but it looks unprofessional for our customer to see
this.

Thanks in advance for you help, I really appreciate it...
Myssie