Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/02/Convert-Negatives-to-Zeros.xlsx

In this video I demonstrate how to convert negative numbers to zeros in Excel. I demonstrate two methods: The first method uses the MAX function and the second applies custom formatting.

This video answers the following queries:

If negative how do I return 0?
If under 0 how do I show 0?
How do I convert negative number to zero?
------------------------