Is there a way to change the error "div/0" in data table to "--" using cond. formatting?

I have a data table that calculates the averages of some data by month. Some months do not have certain averages and that is why the data table calculates them as div/0. I would like to leave those months, but change div/0 to "--". Since it is a data table, i cannot change anything there. So, i was trying to use a conditional formatting formula: ISERROR(A1), special format "--", but it doesn't work. I assume it doesn't, because the custom format works with numbers only. Is there any other way to do it?

Why can't you change the formula within your data table?

Pete

My formula to calculate a data table is to count the averages if the number of jobs are more than "0". How to add there if it is going to be an error not to calculate it?

Originally Posted by alansidman

combine the Iserror with If statement.

If(iserror(A1),"---",Value if no error)

It is conditional formatting formula, not the formula in a cell. In Data table i cannot add the formula to the cell

Originally Posted by alansidman

Look at this as an optional solution. Scroll down.

http://support.microsoft.com/kb/182189

Alan, Thank you so much for your help. This is what i did and it worked to hide it. I wanted to change it to "--", but i will leave it as a blank i guess.