Hide Divide by Zero Option?

macropod · #5 12-15-2013, 09:53 PM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to divide into group	tomlam	Excel Programming	2	05-20-2013 09:46 PM
How to total 12 columns and divide them to get a percentage	Triscia	Word Tables	1	01-15-2013 07:39 AM
formula divide by serio error	vthomeschoolmom	Excel	1	04-18-2012 02:29 PM
divide page into 4 parts	aclark17	Word	4	01-17-2012 09:04 AM
Divide by zero error	doublejoy	Excel	1	08-22-2009 03:10 AM