The problem may be that your sheet shows zeros as blanks, do the following
Office button -- Excel Options -- Advanced -- Display options for this
worksheet -- Show a zero in cells that have zero value.
--
If this helps, please click "Yes"
<<<<<<<<<<<


"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