小写金额转为大写金额公式:
SUBSTITUTE(
SUBSTITUTE(
MFCNUM(INT($MF(付款金额)$))&"元"&IF(INT($MF(付款金额)$)=$MF(付款金额)$,"整","")
&IF(MFISNULL(CONCATENATE(MID(MFCNUM($MF(付款金额)$),FIND(".",MFCNUM($MF(付款金额)$))+1,1),"角")),"",CONCATENATE(MID(MFCNUM($MF(付款金额)$),FIND(".",MFCNUM($MF(付款金额)$))+1,1),"角"))
&IF(MFISNULL(CONCATENATE(MID(MFCNUM($MF(付款金额)$),FIND(".",MFCNUM($MF(付款金额)$))+2,1),"分")),"","零"&CONCATENATE(MID(MFCNUM($MF(付款金额)$),FIND(".",MFCNUM($MF(付款金额)$))+2,1),"分"))
,"零角","")
,"零分","") |