我的公式,别看长,最适用 谢谢楼下的慧眼,现在公式修正了,请检验!!!~~~~~~ 假定你的数据放在表格A1 =IF((TEXT(A2,"#0.00")>0)*INT(--TEXT(A2,"#0.00")),TEXT(INT(--TEXT(A2,"#0.00")),"[dbnum2]"),"")&CHAR(54433*((INT(--TEXT(A2,"#0.00")))>0)+9)&IF(LEFT(RIGHT(TEXT(A2,"#0.00"),2))<>"0",TEXT(LEFT(RIGHT(TEXT(A2,"#0.00"),2)),"[dbnum2]"),IF(AND(RIGHT(TEXT(A2,"#0.00"))<>"0",--TEXT(A2,"#0.00")>1),"零",""))&CHAR(48574*(LEFT(RIGHT(TEXT(A2,"#0.00"),2))<>"0")+9)&IF(RIGHT(TEXT(A2,"#0.00"))<>"0",TEXT(RIGHT(TEXT(A2,"#0.00")),"[dbnum2]"),"")&CHAR(7717*(RIGHT(TEXT(A2,"#0.00"))="0")+47062-54770*(A2=0))
[此贴子已经被作者于2010-5-7 11:50:32编辑过] |