how do you make negative numbers show up as 0 in Excel?
Hello !
go in Format Menu/cells
customize
the type is 0;"0";0
first argument is positive numbers
second is negatives numbers
third is 0 numbers
so the "0" between quotes tells to write 0
the 0 without quotes means the number itself will display
|