怎样能把电子表格中数据统一（6195.80元=陆仟壹佰玖拾伍元捌角）公式，谢谢

Question

怎样能把电子表格中数据统一（6195.80元=陆仟壹佰玖拾伍元捌角）公式，谢谢
差了壹角

Answer 1

你那里原来不是有公式吗，改下就好了。
人民币大写公式太多了，随便搜下就有了，把A1改成你要转换的单元格就好了
=IF(ISNUMBER(A1),SUBSTITUTE(SUBSTITUTE(IF(A1=TRUNC(A1),NUMBERSTRING(A1,2)&"圆整",IF(A1*10=TRUNC(A1*10),NUMBERSTRING(TRUNC(A1),2)&"元"&NUMBERSTRING(MID(A1,FIND(".",A1)+1,1),2)&"角整",NUMBERSTRING(TRUNC(A1),2)&"元"&NUMBERSTRING(MID(A1,FIND(".",A1)+1,1),2)&"角"&NUMBERSTRING(RIGHT(ROUND(A1,2),1),2)&"分")),"零元",""),"零角",""),"非数字值")

Answer 2

这样的公式网上一搜一大把，给一个参考：（J17改为你合计单元）
=IF(J17=0,"",IF(INT(J17),TEXT(TRUNC(J17),"[dbnum2]")&"元","")&IF(MOD(J17,1)=0,"整",IF(TRUNC(J17,1),IF(J17=TRUNC(J17,1),TEXT(LEFT(RIGHT(J17*100,2)),"[dbnum2]0角整"),TEXT(RIGHT(J17*100,2),"[dbnum2]0"&IF(LEFT(RIGHT(J17*100,2))="0","","角")&"0分")),TEXT(J17*100,"[dbnum2]0分"))))