Excel表中怎样把金额变成人民币大写~简单一点的工式就OK了
发布网友
发布时间：2022-06-14 16:57
我来回答
共3个回答
热心网友
时间：2023-05-31 06:18
=IF(ROUND($K$11,2)<0,CONCATENATE("负",IF(ROUND(ABS($K$11),2)<1,"",TEXT(INT(ROUND(ABS($K$11),2)),"[dbnum2]")&"元")&IF(INT(ROUND(ABS($K$11),2)*10)-INT(ROUND(ABS($K$11),2))*10=0,IF(INT(ROUND(ABS($K$11),2))*(INT(ROUND(ABS($K$11),2)*100)-INT(ROUND(ABS($K$11),2)*10)*10)=0,"","零"),TEXT(INT(ROUND(ABS($K$11),2)*10)-INT(ROUND(ABS($K$11),2))*10,"[dbnum2]")&"角")&IF((INT(ROUND(ABS($K$11),2)*100)-INT(ROUND(ABS($K$11),2)*10)*10)=0,"整",TEXT((INT(ROUND(ABS($K$11),2)*100)-INT(ROUND(ABS($K$11),2)*10)*10),"[dbnum2]")&"分")),IF(ROUND($K$11,2)=0,"零",IF(ROUND($K$11,2)<1,"",TEXT(INT(ROUND($K$11,2)),"[dbnum2]")&"元")&IF(INT(ROUND($K$11,2)*10)-INT(ROUND($K$11,2))*10=0,IF(INT(ROUND($K$11,2))*(INT(ROUND($K$11,2)*100)-INT(ROUND($K$11,2)*10)*10)=0,"","零"),TEXT(INT(ROUND($K$11,2)*10)-INT(ROUND($K$11,2))*10,"[dbnum2]")&"角")&IF((INT(ROUND($K$11,2)*100)-INT(ROUND($K$11,2)*10)*10)=0,"整",TEXT((INT(ROUND($K$11,2)*100)-INT(ROUND($K$11,2)*10)*10),"[dbnum2]")&"分")))KII换成你要的单元格
热心网友
时间：2023-05-31 06:18
右击输入数字的单元格，右键菜单选设置单元格格式，弹出对话框选数字－特殊－中文大写数字
热心网友
时间：2023-05-31 06:19
直接把单元格的属性设为“特殊”——“中文大小写数字”就行了！
