And all negative numbers have been changed to zeros. Step2:Then press Enter key, and drag the fill handle across to the range that you want to contain this formula. Step1: In a blank cell, says the Cell E1, input the formula =IF(A1<0,0,a1), see screenshot: The Microsoft Excel's IF function can recognize negative numbers and change them to zero without affect positive numbers. The below example may be easier to understand: there are some negative numbers in a range of cells, and I will guide you to change all negative numbers to zeros at once in the selection.Ĭhange negative number to zero with IF functionĬhange negative number to zero with custom Format CellĮasily change negative number to zero with several clicks Actually there are some easy tips to change negative number to zero conveniently in Excel. Of course, you can manually deal with it one by one if you are patient enough. Says you import some data to Microsoft Excel with many negative numbers, you have to remove all negative numbers and replace them with zero. How to change negative number to zero in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |