Hopefully your numbers are generated by formulas. Then you can modify them
to read
=IF(your_formula<0,0,your_formula)
or
=IF(your_forumula,your_formula,0)
or
your_formula*(your_formula0)
Or, if it is only for appearance and no further calculations are involved,
use a custom format like
#,"0","0"
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
"Jon" wrote in message
...
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