one question is whether just the display needs to be 0.00 or does a cell
referencing the cell need to read 0.00 or the actual value?
Formating the cell does not change the value other cells would read as this
cells value.
the If or max equaitions would be a real zero value

"Penfold" wrote:

I need to create a formula that says if the value is a minus or 0 show 0.00
if there is a positive value show the value.