On Fri, 31 Mar 2006 15:12:32 -0800, Elkar
wrote:

Are these numbers the result of a formula? If so, then you can use the MAX()
function.

=MAX(0,yourformula)

This displays the larger of the two numbers, so if your formula results in a
negative number, the 0 will be larger and thus be displayed.

It will also change the results of any calculations that in turn depend on
this cell. If this is what you want, fine. Alternatively, if you only want
negtive numbers to DISPLAY as zero, use a custom format (as shown in an
earlier response). This won't cause numeric values to change.




"GregP1962" wrote:


how do I make a cell show zero if the number is negative? Excel help
doesn't have this info in a redily available place.


--
GregP1962
------------------------------------------------------------------------
GregP1962's Profile: http://www.excelforum.com/member.php...o&userid=33063
View this thread: http://www.excelforum.com/showthread...hreadid=528761