View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sue Sue is offline
external usenet poster
 
Posts: 285
Default display negative number as zero

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.