View Single Post
  #2   Report Post  
tiah
 
Posts: n/a
Default 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