<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>jslnxs</i>在2009-9-5 20:59:00的发言:</b><br/><p>会08106:jslnxs</p><p></p>=IF(MID(SUBSTITUTE(A2,".0","."),1,1)<>"0",SUBSTITUTE(A2,".0","."),MID(SUBSTITUTE(A2,".0","."),2,15))</div><p>这个公式不对,对有2个0的出错。。。</p> |