is there a function to change negative values to zero?

[Guest]

I am working on an assignment for class and wondered if you could change
negative values in excel to zero without actually typing in the zero

 

[Guest]

Since this is a class assignment, I'll give a suggestion but no solution.
Have you tried using a "worksheet_change" event?

 

[David McRitchie]

If the value is derived from a formula you can use the
MAX Worksheet Function to change the value
For more information on change events see
http://www.mvps.org/dmcritchie/excel/event.htm