in excel, 开发者_Go百科how to display zero in cell when it is empty?
Set the value to '0
instead of just 0
.
You can use a second sheet with a formula like =IF(ISBLANK(A1),0,A1)
on all cells
in excel, 开发者_Go百科how to display zero in cell when it is empty?
Set the value to '0
instead of just 0
.
You can use a second sheet with a formula like =IF(ISBLANK(A1),0,A1)
on all cells
精彩评论