Howto repress "0" if sum = 0

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
 
K

Ken Russell

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
|
 
G

Guest

Right click cell, select format cell, select number tab,
select custom, paste in the following:

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