[已解答]:自定义代码#,##0.00为什么要这样写?

兰色幻想

<p>#,##0.00这句自定义格式代码, </p><p>把#全改成0, 或把0全换成#, 会有什么不同?</p><p>&nbsp;</p>

[此贴子已经被作者于2008-2-16 11:07:12编辑过]

hai

<p>#数字占位符,只显示有效数字.</p><p>0数字占位符,当有效数字给代码数位小时在数值前0补满.</p>

兰色幻想

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>hai</i>在2008-2-16 2:18:00的发言：</b><br/><p>#数字占位符,只显示有效数字.</p><p>0数字占位符,当有效数字给代码数位小时在数值前0补满.</p></div><p>不是解释0和#的用法,是要结合实例分析,为什么要这样设置</p>

秦始皇

<table cellspacing="0" cellpadding="0" width="139" border="0" xstr="" style="WIDTH: 104pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="64" style="WIDTH: 48pt;"></col><col width="75" style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742;"></col></colgroup><tbody><tr height="16" style="HEIGHT: 12pt;"><td width="64" height="16" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font size="2">0,000.00</font></td><td class="xl24" align="right" width="75" xnum="0" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 56pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"><font size="2">0,000.00</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td height="16" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font size="2">#,##0.00</font></td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"><font size="2">0.00</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td height="16" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font size="2">#,###.##</font></td><td class="xl26" align="right" xnum="0" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"><font size="2">.</font></td></tr></tbody></table><p>数据为0时，效果不一样</p><p></p>

兰色幻想

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>秦始皇</i>在2008-2-16 2:59:00的发言：</b><br/><table cellspacing="0" cellpadding="0" width="139" border="0" xstr="" style="WIDTH: 104pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="64" style="WIDTH: 48pt;"></col><col></col><col width="75" style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742;"></col><col></col></colgroup><tbody><tr height="16" style="HEIGHT: 12pt;"><td width="64" height="16" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font size="2">0,000.00</font></td><td class="xl24" align="right" width="75" xnum="0" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 56pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"><font size="2">0,000.00</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td height="16" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font size="2">#,##0.00</font></td><td class="xl25" align="right" xnum="" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"><font size="2">0.00</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td height="16" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font size="2">#,###.##</font></td><td class="xl26" align="right" xnum="0" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"><font size="2">.</font></td></tr></tbody></table><p>数据为0时，效果不一样</p><p></p></div><p></p><font color="#d63108"><strong>最佳答案</strong></font>

工＆贝

<p>原来是这样啊</p><p>学习了</p>

fengwuying

这个是数字用千位分隔符分开，并保留两位小数

onthetrip

为什么呢