如何让excel中小写货币转换为*百*拾*万*千*百*元*角*分

=numberstring(A1，2)

=NUMBERSTRING(INT(A1),2)&"元"&MOD(INT((A1-INT(A1))*10),10)&"角"&MOD(INT((A1-INT(A1))*100),10)&"分"

比如小写在A1,在B1=SUBSTITUTE(SUBSTITUTE(TEXT(TRUNC(FIXED(A1)),"[>0][dbnum2];[<0]负[dbnum2];;")&TEXT(RIGHT(FIXED(A1),2),"元[dbnum2]0角0分;;"&IF(ABS(A1)>1%,"元整",)),"零角",IF(ABS(A1)<1,,"零")),"零分","整")

假如A1里数值为12345.67,在B1输入公式:
=IF((A1-INT(A1))=0,TEXT(A1,"[DBNUM2]")&"元整",IF(INT(A1*10)-A1*10=0,TEXT(INT(A1),"[DBNUM2]")&"元"&TEXT((INT(A1*10)-INT(A1)*10),"[DBNUM2]")&"角整",TEXT(INT(A1),"[DBNUM2]")&"元"&IF(INT(A1*10)-INT(A1)*10=0,"零",TEXT(INT(A1*10)-INT(A1)*10,"[DBNUM2]")&"角")&TEXT(RIGHT(A1,1),"[DBNUM2]")&"分"))
就会在B1自动转换成大写。想放在哪个单元格，你自己修改一下好啦。