Try this amendment to your existing formulae in those cells:

=MAX(0,existing_formula)

Hope this helps.

Pete

On Apr 30, 1:42*pm, 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