display negative number as zero

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am doing a inward/outward stocktake and sometimes it returns a negative
number. I want to be able to display this negative number as zero but display
any positive numbers as they are.
 
If you want to display 0, but retain the negative value in the cell, you
could try a custom number format:

#;"0";0
 
Back
Top