Excel人民币转大写公式
=SUBSTITUTE(SUBSTITUTE(TEXT(INT(C25),"[DBNum2][$-804]G/通用格式元"&IF(INT(C25)=C25,"整",""))&TEXT(MID(C25,FIND(".",C25&".0")+1,1),"[DBNum2][$-804]G/通用格式角")&TEXT(MID(C25,FIND(".",C25&".0")+2,1),"[DBNum2][$-804]G/通用格式分"),"零角","零"),"零分","")=SUBSTITUTE(SUBSTITUTE(TEXT(INT(C25),"[DBNum2][$-804]G/通用格式元"&IF(INT(C25)=C25,"整",""))&TEXT(MID(C25,FIND(".",C25&".0")+1,1),"[DBNum2][$-804]G/通用格式角")&TEXT(MID(C25,FIND(".",C25&".0")+2,1),"[DBNum2][$-804]G/通用格式分"),"零角","零"),"零分","")