Show zero values


J

johnny

When a formula returns a zero value, the zero value is not being
displayed.

I have reviewed the following:
- conditional formatting
- zero values are checked (Tools/Options/View)
- stepped through my VB code (it inserts formulae based on a Worksheet
Change event)
- locked and hidden values unchecked with and without protection (this
should have no effect when the sheet is unprotected)

Are there any other circumstances that result in a zero value not being
displayed? Are there any other reasons for this occurrence?

Cheers
John
 
Ad

Advertisements

G

Guest

Check also normal cell formatting! there are formats that hide either
positive or negative or zero or all numbers! E.g. custom format ;;; hides all
numbers!

Regards,
Stefi


„johnny†ezt írta:
 
G

Guest

Could it be as simple as standing in SheetB!B1 and write
=IF(SheetA!A1="0";"0";SheetA!A1) - SheetA!A1 being the cell the zero value is
returning from and SheetB!B1 being the cell the zero value is returning to.
Works for me - hope you can use it.
 
D

Dave Peterson

Along with the custom format of: ;;;
you might want to check for format|conditional formatting.
(maybe it's returning the 0, then hiding it.)

Or maybe it's an error in the formula. You may want to post that formula that
you're putting in the cell.
 
Ad

Advertisements

D

Dave Peterson

And check to see if calculation is set to automatic, too.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top