OK, copy/ paste special Values to see the actual value, then undo it so you
don't lose the formula. If there's a negative value in there normally,

=IF('April 15'!E26<0,0,'April 15'!E26)

Should work fine...

"Jon" wrote:

this is a summary page from a months worth of data ='April 15'!E26 is what
appears in the formula bar.
thanks
--
Jon


"Sean Timmons" wrote:

If you look at the Formula bar, is the number 0 in there?

Ensure your Cell Format is set as Number, 0.

"Jon" wrote:

I've tried that and the cell goes blank
--
Jon


"BSc Chem Eng Rick" wrote:

Hi Jon,

Use this formula:
=IF("Cell Reference"<0,0,"Cell Reference")
--
If this helps, please click "Yes"
<<<<<<<<<<<


"Jon" wrote:

I have a summary sheet for a month's worth of data and I need the negative's
that appear to come out as zero's
--
Jon