Forcing Negatives to display as zero

[Habanero]

Any ideas how to force a negative number to display as
zero?

 

[Peo Sjoblom]

General;"0"

 

[Andy B]

Habanero

A couple of ways:
Use a custom format.
Enclose your formula in a MAX function:
=MAX(yourformula,0)

Andy.

 

[Habanero]

Thanks so much!!

-----Original Message-----
General;"0"


--

Regards,

Peo Sjoblom





.

 

[Guest]

Use the function +Max(0,.....)

 

[J.E. McGimpsey]

If you just want it to display as zero:

Format/Cells/Number/Custom General;"0";0;@