当前位置：你问我答网 > 综合

Excel中怎样快速地将合计后的小写数字金额转换成大写汉字金额？

2023-05-15 综合 27阅读

　　用公式来转换

　　=IF(A1=0,"",IF(A1<0,"负","")& SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(ABS(A1)),"[DBNum2]"闭坦)&"元"&SUBSTITUTE(SUBSTITUTE(TEXT(RIGHT(A1*100,2),"[DBNum2]0角0分"),"零分","整"),"零角","零"),"零元零",),"零元",),"零整行明","整轿带桐"))

　　

声明：你问我答网所有作品（图文、音视频）均由用户自行上传分享，仅供网友学习交流。若您的权利被侵害，请联系fangmu6661024@163.com
0

猜你喜欢