Jon, I am not sure whether you have tried the suggestion of custom formatting
the cells to

General;"0";0
(This will display 0 for -ve values and 0's)

General;"0";""
(The above will display 0 for -ve values and blank for 0's)

--
Jacob (MVP - Excel)


"Jon" wrote:

Thanks, I've tried these and they just come back blank. In other cells when
they are zero's they come back as a zero value.
--
Jon


"Bernard Liengme" wrote:

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

.