=IF(yourformula<=0,"0.00",yourformula)


--
HTH

Bob Phillips

<Andy B wrote in message ...
Hi
You can do that with formatting or you could use something like:
=IF(yourformula<0,0,yourformula)

--
Andy.


"Penfold" wrote in message
...
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.