You need a formula in a 2nd column: =MAX(A1,0)


On 14 Jan 2005 10:10:42 -0800, "Dede" wrote:

Greetings!

How do I create a function that will change a range of cells that are
all negative numbers to zero? I want to keep the orginal negative
numbers as well. Thank you!!!