Convert Negative Numbers to Zeros in Excel

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?
------------------------

[AMSportsPicks-ells]

Fixed what I have been trying to correct for hours. Thank you

[virsanjay]

simple and clear explanation... Thanks

[aarefalokhandwala]

I was stuck at that part while analysing data. Thanks for helping.

[ahmeds]

Thank you this helped me a lot. I want to make it a word like out of stock. Can you show me how?
Thank you again

[ellieribas]

omg! you saved me in a few seconds. Thank you so much, sir!

[bharatmehta]

Solved my problem in seconds, awesome

[abdelkaderboukra]

Thanks bro, this is what i was looking for

[rockyel]

hi lord chester how do you apply this without formula? thank you sir

[shubhamargulwar]

Do one video how to convart text in table

[kyidennis]

So simply thank you, I have been searching but I can't find the answer I want to work out the percentage or figure essentially 75k - 100k 5% 101k - 150k 10% but i have no idea how to do this any help would be great

[bg]

Hi Sir, what to do if the values you want to become zero are straight from a formula?

[lunatic]

Sir how to use this formula in open source excel?