Hi

Fredrik's solution hides all zero values in workbook. When you want hide
zeros in specific cells, or on specific conditions, then you have to use my
solution instead.


Arvi Laanemets


"cburgess57" wrote in message
...
Thank you! That did work, however if the answer to the formula is
actually
Zero, then it takes that zero away also...any way around this??? Thanks!

"Fredrik Wahlgren" wrote:


"cburgess57" wrote in message
...
I'm trying to find out how to get rid of a zero when a formula is
used,
but
there has not been any data entered in that row yet. For example, as
simple
as copying another cell, you put =b11, if nothing has been entered in
b11
yet, it shows a zero, but I dont' want it to show anything...

help!

Select Tools|Options. Select the Display tab. There's an option called
zerovalues that should be unchecked. Unfortunately, I have the Swedish
version so it's possible my translation isn't correct.

/Fredrik