开发者

how to display zero in cell when it is empty

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜