Howto repress "0" if sum = 0

  • Thread starter Thread starter David Lewis
  • Start date Start date
D

David Lewis

I am doing a timesheet and for rows that do not get time at the end
it displays a sum of 0. How do I not show the 0
 
Tools/Options/View, untick zero box.

--
Ken Russell

| I am doing a timesheet and for rows that do not get time at the end
| it displays a sum of 0. How do I not show the 0
|
 
Right click cell, select format cell, select number tab,
select custom, paste in the following:

#,###_);(#,##_)
 
Back
Top