How can I display negative numbers as zeros?

[Guest]

I cannot figure out how to display a negative number as zero. Is there an
easy way to do this?

 

[Guest]

Custom format:

0;"0"

 

[Dave Peterson]

Use a custom format of: General;\0;0;@

Positive numbers;negative numbers;zeros;text

The display will be 0, but the value will still be negative.

 

[Guest]

if you want it to calculate as zero
=max(A1,0)
otherwise the format methods are best