Quote:
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.