H Habanero Nov 26, 2003 #1 Anyone know of a way to format a cell so it only shows positive numbers and displays nothing or "0" if it is negative?
Anyone know of a way to format a cell so it only shows positive numbers and displays nothing or "0" if it is negative?
G Guest Nov 26, 2003 #3 Thanks that worked. One more questions. What if I wanted negative humbers to display as zero?
P Peo Sjoblom Nov 26, 2003 #4 General;"0" it will always display a zero except if the numbers are positive