jacky
问题补充说明：想让他变成"US DOLLARS TWELVE THOUSAND FIVE HUNDRED AND NINETY THREE"，怎么编写函数啊;例如数字为12593
B1公式下拉：
=SUBSTITUTE(SUBSTITUTE(IF(-RMB(A1,2),TEXT(A1,";负")&TEXT(INT(ABS(A1)来自+0.5%),"[dbnum2]G/360问答通用格式圆;;")&TEXT(RIGHT(RMB(A1,2),2),"[dbnum2]0角0分;;整"),),"零角",IF(A1^2<1,,"零")),"零分","整")
