Hide Divide by Zero Option?

[macropod]

Originally Posted by SteveBump

Rather than pick which format or option to choose, they could simply leave it up to the user. In other words:

Display #DIV/0! error as: _____________

And then the user could put in " ", 0, -, etc.

No Excel version to date has supported that, and I doubt MS is about to introduce such a change - it would probably break backwards compatibility, meaning worksheets using it couldn't be used on older systems. Somehow I doubt users would welcome such unsupported features: (a) causing crashes; or (b) being converted to text instead of formulae.