
ABS
=SUBSTITUTE(SUBSTITUTE(IF(-RMB(A1),IF(A10,,"负")&TEXT(INT(ABS(A1)),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(RMB(A1,2),2),"[dbnum2]0角0分;;整"),),"零角",IF(A1^21,,"零")),"零分",)这个代码会根据输入的金额进行金额转换,并输出以大写形式呈现。例如,如果输入3,200.00,则输出结果将是?3,200。同时,零角和零分也会被正确地添加到结果中。Copyright © 2025 IZhiDa.com All Rights Reserved.
知答 版权所有 粤ICP备2023042255号