View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
eva cheng eva cheng is offline
external usenet poster
 
Posts: 11
Default A SUM FUNCTION (EXCEL) RETURNS A ZERO VALUE BUT DISPLAY IN (0.00),

I AM USING THE SUM FUNCTION OF EXCEL 2003, IT RETURNS A ZERO VALUE WHEN
SUMMING A COLUMN OF FIGURES WHICH ARE NOT RESULTING FROM A FORMULA. IT
DISPLAYS (0.00) INSTEAD OF 0.00. WOULD YOU PLEASE HELP ME REMOVE THE BRACKETS
FROM A ZERO VALUE ? THANKS