Suggest that it would be better to consider (to cover result = 0)
=if(resultofyour formula0,resultofyourformula,0)
and before copying format to 2 decimal places.

If it was my spreadsheet consider using conditional format so that
If value < 0 then fontcolour = white
If value = 0 then fontvolour = white

This means that only results with positive values have any figures showing
--
Don C


"Andy B" wrote:

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.