View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kshomebrew
 
Posts: n/a
Default how do you make negative numbers show up as 0 in Excel?

Hi, this worked great, but now my decimals are missing. Any Help?

"tiah" wrote:

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