Formula returning a blank cell if answer is zero

[Rich]

In Excel 2003, I have a worksheet that has formulae in a column. If the
result is zero, it displays a zero. I copied the column to another worksheet
and on that worksheet, if the result is zero, the cell is blank. Where is
the switch to have it show zero or show blank? I'm quite sure it exists...I
just don't know where.

Thanks,

 

[Chris Premo]

In Excel 2003, I have a worksheet that has formulae in a column. If
the result is zero, it displays a zero. I copied the column to
another worksheet and on that worksheet, if the result is zero, the
cell is blank. Where is the switch to have it show zero or show
blank? I'm quite sure it exists...I just don't know where.

Thanks,

=IF(ISBLANK(A1),"",0)

--

 

[Chris Premo]

In Excel 2003, I have a worksheet that has formulae in a column. If
the result is zero, it displays a zero. I copied the column to
another worksheet and on that worksheet, if the result is zero, the
cell is blank. Where is the switch to have it show zero or show
blank? I'm quite sure it exists...I just don't know where.

Thanks,

oops, re-read your subject line.


=IF(OR(ISBLANK(B3),B3=0),"",0)

--

 

[Rich]

Chris,

Remember, both worksheets have the same formula...neither saying anything
about blanks, zeros, or anything...yet one shows 0, while the other shows
blank. Isn't there a toggle someplace to set this option?

Thanks,

 

[Dave Peterson]

Tools|Options|view tab|uncheck Zero values.

Or maybe you have a numberformat that hides the zero by using the same font
color as fill color. Try changing the numberformat to General.

You could also use a custom number format to just hide the 0's. Changing the
numberformat to General will fix this, too.

Or maybe you have Format|conditional formatting set to hide the 0's???

 

[Dave Peterson]

ps. Unchecking Zero values will hide them. Checking it will show them.

(just to be clear)

 

[Chris Premo]

Chris,

Remember, both worksheets have the same formula...neither saying
anything about blanks, zeros, or anything...yet one shows 0, while
the other shows blank. Isn't there a toggle someplace to set this
option?

Thanks,

Crtl-1 and set the cell type?
--

 

[depaul0220]

In Excel 2003, I have a worksheet that has formulae in a column.  If the
result is zero, it displays a zero.  I copied the column to another worksheet
and on that worksheet, if the result is zero, the cell is blank.  Whereis
the switch to have it show zero or show blank?  I'm quite sure it exists...I
just don't know where.

Thanks,

=IF(Formula=0,"",Formula)