Zero (0) in cell

		Microsoft Office Forums > Microsoft Excel > Excel
Zero (0) in cell

FAQ

Thread Tools

Display Modes

01-18-2011, 07:26 PM

macropod

Windows 7 32bit Zero (0) in cell

Office 2000

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,527

Quote:

Originally Posted by ConneXionLost

You can use a custom format like this:

Code:

#,##0_);(#,##0);""

but, be warned, it will hide ALL zeros.

No, it'll only hide 0s in the cells to which the custom format is applied.

An alternative is to modify the formula. For example:
=IF(A1+B1=0,"",A1+B1)
or:
IF(OR(A1=0,B1=0),"",A1+B1)
The first hides the result only if it evaluates to 0, whereas the second hides the result if either of the inputs is 0.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM
How can I make a cell color RED under the Today's date cell?	Learner7	Excel	2	07-08-2010 12:52 AM
Help reg Protection of cell.	aligahk06	Excel	1	09-02-2009 05:45 PM
Cell formatting	Niko	Excel	5	04-23-2009 12:05 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:23 PM.