|
<P>下面给你一个,在A9中输入数字即可,如果是其他单元格,替换一下。</P><P>A1=IF(A9=0,"零",(IF(TRUNC(A9)=0,"",TEXT(TRUNC(A9),"[DBNum2]G/通用格式")&"元"))&(IF(AND(TRUNC(A9)<>0,TRUNC(A9*10)-TRUNC(A9)*10=0,TRUNC(A9*100)-TRUNC(A9*10)*10<>0),"零",IF(AND(TRUNC(A9)<>0,TRUNC(A9*10)-TRUNC(A9)*10=0,TRUNC(A9*100)-TRUNC(A9*10)*10=0),"整",IF(TRUNC(A9*10)-TRUNC(A9*10,-1)=0,"",TEXT(TRUNC(A9*10)-TRUNC(A9*10,-1),"[DBNum2]G/通用格式")&"角")))))&(IF(TRUNC(A9*100)-TRUNC(A9*10)*10=0,"",TEXT(TRUNC(A9*100)-TRUNC(A9*10)*10,"[DBNum2]G/通用格式")&"分"))</P> |
|