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