自定义格式(隐藏0值)!

hai

<table cellspacing="0" cellpadding="0" width="320" border="0" xstr="" style="WIDTH: 240pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="2" width="72" style="WIDTH: 54pt;"></col><col width="176" style="WIDTH: 132pt; mso-width-source: userset; mso-width-alt: 5632;"></col></colgroup><tbody><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" width="72" height="22" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;"><p><font face="新細明體">工作表</font></p></td><td class="xl24" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">EP</font></td><td class="xl24" width="176" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 132pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">60</font></td></tr><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" height="22" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;"><font face="新細明體">EP</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">0</font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">工作表</font></td></tr><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" height="22" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;"><font face="新細明體">-1</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">50</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">-300</font></td></tr></tbody></table>如题! 请用回复贴方法!前5名每人两个!

qxbpeter

游客，如果您要查看本帖隐藏内容请回复

jzx79

游客，如果您要查看本帖隐藏内容请回复

工具--------选项------视图----------零值(把钩去掉)确定就可以了

jzx79

游客，如果您要查看本帖隐藏内容请回复

还有一个方法,就是选择要隐藏零值的单元格右击设置单元格格式,在分类里选择自定义：类型为：0;-0;;@确定就可以

wingfeng45

<p>楼上的回答好全面，就收来学习啦</p>

ys226

游客，如果您要查看本帖隐藏内容请回复

[此贴子已经被作者于2008-3-18 10:45:17编辑过]

exceletyn

游客，如果您要查看本帖隐藏内容请回复

莹莹一笑

游客，如果您要查看本帖隐藏内容请回复

猫

隐藏零值：G/通用格式;-#;;@

猫

感谢楼主出的题目，让我知道 了快捷键CTRL+1“打开单元格格式对话框。”