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.

johnny wrote:

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

--

Dave Peterson