想請問我有個excel file....內裏有好多0.00數字.....現想改成空白..但不想用人手改
我己試過取代或設定儲存格都不成...請各位指教
excel 問題
2007-06-12 1:35 am
回答 (1)
2007-06-12 1:49 am
✔ 最佳答案
1. On the TOOLS menu, click OPTIONS, and then click the VIEW tab. 2. Do one of the following:
To display zero values as blank cells, CLEAR THE CHECK BOX.
參考: Microsoft Excel Help - Display or hide all zero values on a worksheet
收錄日期: 2021-04-28 23:54:04
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070611000051KK02976