Deleting the #DIV/0! from cells

[TashWilliams]

How do I remove #DIV/0! without deleting them. Is there a formula which I can apply so that the words don't show.

Thank You

Tash Williams

[NBVC]

What's the formula that is displaying the error in the first place?....that formula can be altered so that it doesn't return the error.

[furiousboy]

if you just need to hide it go to format cell select custom and where by default it should say "general" enter ";;;" and it will hide the cells contents for you, it will still be viewable from the cell address bar but not in the cell itself

[TashWilliams]

Thank You very much that's exactly what I wanted to do.

Tash