分享一个人民币小写转大写的公式

翻出来一个强大实用的东东，人民币大小写转换公式，大家可以参考：

IF(LEFT(MFCNUM(ROUND($MF(金额)$,2),2,0))="拾","壹","")&MFCNUM(INT(ROUND($MF(金额)$,2)),2,0)&"元"&CHOOSE(LEN(MFCNUM(ROUND($MF(金额)$,2),2,0))-LEN(MFCNUM(INT(ROUND($MF(金额)$,2)),2,0))+1,"整","",RIGHT(MFCNUM(ROUND($MF(金额)$,2),2,0))&"角整",LEFT(RIGHT(MFCNUM(ROUND($MF(金额)$,2),2,0),2))&"角"&RIGHT(MFCNUM(ROUND($MF(金额)$,2),2,0))&"分")

非常有用，感谢分享